Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET
i am doing my mca final year project in asp.net using c# coding. this is the web based project. actually i need the coding for inserting the data to database.
Posted 18-Jan-10 1:54am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Any ADO.Net book would tell that. And since you are doing MCA, I assume you have one. So, only thing left is reading it.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Create database, create connection, and then use this code in your project to insert the data
 


string connStr = "Data Source=.;Initial Catalog=DatabaseName;Integrated Security=True";
SqlConnection dbCon = new SqlConnection(connStr);
SqlCommand sqlCmd;
DataTable dbTbl;
SQLCommand sqlCmd;
sqlCmd = new SqlCommand();
dbCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Connection = connStr ;
sqlCmd.CommandText = ("INSERT INTO TABLE NAME VALUES(A,B,C) ");
sqlCmd.ExecuteNonQuery()
dbCon.Close();

 
use this code and u will get inserted your data
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 381
1 Praneet Nadkar 237
2 Marcin Kozub 225
3 Sergey Alexandrovich Kryukov 195
4 Shweta N Mishra 161
0 OriginalGriff 8,284
1 Sergey Alexandrovich Kryukov 7,327
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,920


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 18 Jan 2010
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100