9 questions
0
votes
0
answers
128
views
datagridview and combobox in offline Mode
I want to display in a datagridview informations of books that he's author is selected in combobox, in offline mode.
I wrote this code to fill the combobox with ahutor's name
private void ...
- 51
0
votes
2
answers
1k
views
SQLDataAdapter changing value type returned from SQL
In my C# project, I am executing a query against a SQL 2014 database to retrieve Employee data, including a PeriodEnd which is stored in the database as a Decimal (i.e., Nov 17, 2016 is stored as ...
- 4,205
0
votes
1
answer
35
views
Save DataGridView into SQL Server
I'm trying to save changes from my DataGridview back into the SQL Server 2008. I have the following code but it only updates the DB the first time the button is clicked. Where am I overlooking ...
- 173
1
vote
1
answer
913
views
DataAdapter update not working against an Access DB [duplicate]
I'm trying to create a class to store my connection string and general functions for insert, update and delete.
Testing the INSERT function, it seems to complete the process without any errors but ...
- 788
0
votes
1
answer
92
views
vb.net radiobuttonlist containing 3 buttons not firing when selectedindexchanging from index 2 to 0 under one condition
My code fills a DataGrid control (vb.net 3.5 framework) using sqldataadapter and dataset, filtered by selections from a combination of other controls. Everything works fine except RadioButtonList1 ...
- 746
1
vote
1
answer
789
views
CommandTimeout being ignored using DbDataAdapter.Fill
I cannot seem to get the CommandTimeout to work in the code below. I set the timeout value to 1 second just to test to ensure it works but it seems to be ignored. The SELECT statement takes about 15 ...
- 2,801
0
votes
4
answers
755
views
Why I get Incorrect syntax near '=' error
I tried bind a label from datatable
I get this error
Incorrect syntax near '='.
at this line
da.Fill(dt);
My code : Page_Load
LbLID.Text =this.Page.Request.QueryString["DI"].ToString();
...
- 769
0
votes
2
answers
6k
views
SQL Data Adapter Insert Command
There seems to be a problem with the following code I would like to insert a value in the database using the following code snippet.
DataTable dtUsers = new DataTable("tblUsers");
BindingSource ...
- 1
0
votes
3
answers
561
views
I have 10 columns in table, but i want to display only 4 columns in datagrid in c#, how can i do it?
I can't found solution... i have set 4 columns in DataGrid view but when i am using SqlDatAdapter and DataTable it displaying all columns .
- 1