Click here to Skip to main content
12,635,011 members (29,290 online)
Rate this:
 
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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 18 Jan 2010
Copyright © CodeProject, 1999-2016
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