Member Avatar

Working with Microsoft Visual Studio 2010 Professional, using C#, with Microsoft SQL Server 2008. I have been tasked with taking an existing application, and making changes so that it can receive multiple languages in its text boxes without needing to configure ahead of time what language is to be used. To ensure that I am doing this correctly, I have created a new table in the database, called Language. If I can get things working correctly with [Language], I should be able to get it all working. The field in question is "MotherTongueLanguageName": CREATE TABLE [Language]( [LanguageID] [tinyint] IDENTITY(1,1) NOT …

Member Avatar
0
38
Member Avatar

` connectionString="Data Source=########;Initial Catalog=DowntimeD51;Persist Security Info=True;User ID=#######;Password=########;Connection Timeout=120;Encrypt=False;TrustServerCertificate=False;Network Library=dbmssocn"` I have the above connection string in a vb windows application , This is part of my app config file. I then have a number of table adapters for connecting my business logic to the database , One of the queries inparticular is a pretty large one and requires extra time to complete however the connection is getting a timeout error. When I checked the adapter connection with `Dim connection2 As Int32 = Adapter1.Connection.ConnectionTimeout` This shows the connection time out to be 120 seconds but the timeout is still occuring after …

Member Avatar
0
3
Member Avatar

In Visual Studio 2010, I have a windows forms application frmMain.cs with a ComboBox. From the form itself I can access its value with cmbxYear.SelectedValue. I also have a DataSet.xsd file to bind to an rdlc report to a TableAdapter to present view data. The TableAdapter has a SelectCommand that takes SQL code. I need to get the value of cmbxYear.SelectedValue into the WHERE clause of the TableAdapter. Does anyone know how I can access/pass the variable value from the form into the DataSet TableAdapter SelectCommand WHERE clause? (I am open to other ideas of how to filter an rdlc …

Member Avatar
0
3
Member Avatar

Hello to all, sorry if my english is not so good, I will try to explain the problem. I need to copy all data from a Table of a Acces mdb (connected with OleDB) to a Table of a MySql DB (connected with ODBC) I made a working solution, but it's very slow, and so I want to try other solutions to check if they can give me more performance. The solution connecting to the mdb, using a DataReader, then for each row in Datareader I make an INSERT into the Mysql Table ( before copy I truncate the table …

0
1
Member Avatar

I’m fairly new to C#, especially with databases. I’ve worked in VBA and Delphi doing databases, so I was hoping to just use this like a RecordSet or a Tcursor, but so far it’s not panning out like that. I have a SQL database added as a dataset in my project (Windows forms). For a given table (“HTC”) I have a TableAdapter set up, and it includes 2 custom queries. One gets the active record and the other gets the cancelled records. Both of these queries have a parameter so they only pull for a single account (“GPN”). Right now …

Member Avatar
0
5

The End.