Click here to Skip to main content
15,901,373 members
Home / Discussions / Database
   

Database

 
GeneralRe: Load a file into a binary column in SQL server Pin
Jeff Varszegi18-Nov-03 5:38
professionalJeff Varszegi18-Nov-03 5:38 
GeneralSQL Server Date Problem Pin
sim_san15-Nov-03 1:16
sim_san15-Nov-03 1:16 
GeneralRe: SQL Server Date Problem Pin
Mike Dimmick15-Nov-03 1:55
Mike Dimmick15-Nov-03 1:55 
GeneralRe: SQL Server Date Problem Pin
sim_san17-Nov-03 6:40
sim_san17-Nov-03 6:40 
GeneralRe: SQL Server Date Problem Pin
Mike Dimmick17-Nov-03 6:54
Mike Dimmick17-Nov-03 6:54 
GeneralRe: SQL Server Date Problem Pin
sim_san22-Nov-03 6:23
sim_san22-Nov-03 6:23 
GeneralRe: SQL Server Date Problem Pin
Anonymous21-Nov-03 5:45
Anonymous21-Nov-03 5:45 
GeneralsqlDataAdapter Wizard does not Update Pin
Bruce L. Scheffler14-Nov-03 11:39
sussBruce L. Scheffler14-Nov-03 11:39 
Real simple problem but it is driving me nuts.
Create a table in SQL with two columns.
NameId and FullName
Make the NameId a primary Key.
Add a nameid and a fullname to the table.
Save the table as NameId.

Now using only the .net wizards for a windows forms project I do the following:

1. Create new project (windows forms)
2. Drag two textboxes onto the form.
3. Drag a button onto the form.
4. Drag a sqlDataAdapter onto the form which starts the wizard.
5. Connect to the sqldatabase for the table.
6. Allow it to create the sql statements.
7. Create the query using both fields.
8. Do not change the advanced settings.
9. Save the wizard.
10. Create a dataset using the NameId table.
11. Bind the two textboxes to the table fields via their respective properties.
12. On the window form events create an event for load.
13. Enter the fill method of the sqldataadapter:
this.sqlDataAdapter1.Fill(this.dataset1, "NameId");
14. Return to the design screen and create an click event for the button under its respective events.
15. In the code enter the following:
this.sqlDataAdapter1.Update(this.dataset1, "NameId");

now compile
my results are the form will display the one record, however when I change the fullname field to something else it does not update the sql NamId table...

What am I doing wrong...
Smile | :) Bruce...


GeneralJoin Pin
Anonymous14-Nov-03 8:25
Anonymous14-Nov-03 8:25 
GeneralRe: Join Pin
jeff_martin14-Nov-03 9:52
jeff_martin14-Nov-03 9:52 
GeneralRe: Join Pin
Anonymous17-Nov-03 2:39
Anonymous17-Nov-03 2:39 
Generalsql Pin
ranjjj13-Nov-03 17:18
ranjjj13-Nov-03 17:18 
GeneralAccess Query Pin
bgeroux13-Nov-03 16:25
bgeroux13-Nov-03 16:25 
GeneralRe: Access Query Pin
Hesham Amin13-Nov-03 21:28
Hesham Amin13-Nov-03 21:28 
GeneralRe: Access Query Pin
Roger Wright14-Nov-03 3:14
professionalRoger Wright14-Nov-03 3:14 
GeneralRe: Access Query Pin
bgeroux14-Nov-03 3:43
bgeroux14-Nov-03 3:43 
GeneralRe: Access Query Pin
Roger Wright14-Nov-03 4:19
professionalRoger Wright14-Nov-03 4:19 
GeneralRe: Access Query Pin
Mike Dimmick15-Nov-03 1:52
Mike Dimmick15-Nov-03 1:52 
GeneralRe: Access Query Pin
bgeroux15-Nov-03 6:31
bgeroux15-Nov-03 6:31 
Generaldbms_pipe Pin
mhmoud rawas12-Nov-03 18:30
mhmoud rawas12-Nov-03 18:30 
GeneralRe: dbms_pipe Pin
Mike Dimmick13-Nov-03 23:22
Mike Dimmick13-Nov-03 23:22 
GeneralRe: dbms_pipe Pin
mhmoud rawas14-Nov-03 20:01
mhmoud rawas14-Nov-03 20:01 
GeneralRe: dbms_pipe Pin
Mike Dimmick15-Nov-03 1:30
Mike Dimmick15-Nov-03 1:30 
GeneralRe: dbms_pipe Pin
mhmoud rawas15-Nov-03 18:36
mhmoud rawas15-Nov-03 18:36 
GeneralSQL get some ZERO's Pin
student()12-Nov-03 11:52
sussstudent()12-Nov-03 11:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.