Part 1 of 5: Adding data to SQL Server with C# and ADO.Net
Loading...
Link to this comment:
Uploader Comments (BablioBr)
All Comments (140)
-
@BablioBr my IDE would just tell me \ is an unrecognized escape sequence :(
-
good lesson! ; )
-
Great Friend I just wanted to know That..Thanks a A lot Bro.. Send me your email..
-
Great Videos!!! I made my whole project just by watching your Videos!! Bundles of Thanks!! Keep up the great work!!!
-
man, you rule....great knowledge :) thanks, your videos helped me a looooot ...
-
@BablioBr What if i have a table Student and want a field that displays student picture in a pictureBox (and also be able to browse image files and change it), StudentID could be foreign key of ImageDB table (assuming we have Student and ImageDB tables separate) and somehow find a way so that when selecting a specific row from datagrid pictureBox gets updated with image linked to that StudentID
-
The messageBox comes up but i cannot continue inserting, the code i originally have is
void insert() { String FirstName = "";
10:01Part 3 of 5: Using BindingSource to navigate th...by BablioBr34,577 views
- 6:35Part 4 of 5: Editing SQL data using the SqlData...by BablioBr22,973 views
- 0:48WPF Login Form With Video Clipby hectorsmith7863,535 views
- 10:01Part 1 of 2 - How to: Connect to SQL Server usi...by BablioBr72,360 views
- 9:50Part 2 of 2 - How to: Connect to SQL Server usi...by BablioBr45,684 views
- 5:50Part 5 of 5: Deleting Data from SQL using SqlDa...by BablioBr20,125 views
- 6:39C# - How to create a class, objects and add mem...by BablioBr8,636 views
- 3:40Creating Reports in C# - Part 2 of 2by BablioBr22,503 views
- 7:13c# datagridview tutorial part 1by certainan22,270 views
- 7:56Visual basic database add, remove & save buttonsby networking26216,286 views
- 6:55Create Setup EXE file using a Visual studio 200...by sonusoftstar2,371 views
- 8:30Connect to MySQL Database with Connector/J and ...by ted6021116,296 views
- 0:47Design Example C# WPFby LanGhost1722,988 views
- 12:37INSERT, DELETE, UPDATE AND SELECT Data in MS-Ac...by iechsetha32,872 views
- 8:56C# - How to save images to a local databaseby BablioBr3,763 views
- 5:22VISUAL STUDIO 2010 Making an Excel 2010 add inby MyWorkHome3,359 views
- 7:56C# Form Databaseby WSKYradio45,230 views
- 7:56Delete/Update with Datagridview tutorial - Part 2by certainan29,815 views
- 7:17C Sharp C# ASP.net tutorial 2 (Inserting Data i...by vadlak1220,143 views
Couple of things: First .. "...Data Source=.\\SQLEXPRESS;..." 2 backslashes? Try ".\SQLEXPRESS" instead of ".\\SQLEXPRESS" Second: "; Integrated Security=TRUE");" means that Windows Authorization is enabled.. perhaps you need to enter the SQl user name and password... Try using this instead of "Integrated Security=TRUE": ";User Id=myUsername;Password=myPassword;" I hope this helps.. good luck.
BablioBr 9 months ago
Hi, just finished your 1-5 tutorial but got an error in this video. I get an error when it reaches "da.InsertCommand.ExecuteNonQuery();" it says
"Column name or number of supplied values does not match table definition."
Tried everything but to no avail. the lesson 2 to 5 were done except for this.
karlinoDS 1 year ago
@karlinoDS Without looking at you code, my best guess is that your ID column is the problem. "Column name or number of supplied values does not match table definition. "Column name" - make sure your INSERT sql has the right syntax.. correct spelling of the column names. "Number of supplied values does not match table definition" - make sure you are passing all value to all column.
BablioBr 1 year ago
@karlinoDS In regards to the ID column in SQL make sure it has this specifications: Identity Specification: Yes; (is Identity): Yes; Identity Increment :1; Identity Seed: 1; I hope this will help.
BablioBr 1 year ago