[bunny20]

I want to add a data in the database but I don't know the right code in connecting the database.

Below is the code;

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
	protected void Page_Load(object sender, EventArgs e)
	{

	}
	protected void cmdSave_Click(object sender, EventArgs e)
	{
	  
	  string connectionString ="SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\jojo\My Documents\Visual Studio 2005\Projects\Testing\Core\testinglang.mdf";Integrated Security=True;User Instance=True";

			SqlConnection connection = new SqlConnection();

			connection.Open();

			SqlCommand cmd = new SqlCommand("SELECT * FROM [testinglang]",connection);
	
  
	 LastName = Lname.Text;
	 FirstName = Fname.Text;
	 MiddleName = Mname.Text;
	 connection.Update();

		string message = "New User Account Successfully Sav\r\n" + Fname.Text;
		string caption = "User Account";
		MessageBoxButtons buttons = MessageBoxButtons.OK;
		MessageBoxIcon icon = MessageBoxIcon.Information;

	 MessageBox.Show(message, caption, buttons, icon);

	 cmd.ExecuteNonQuery();

	 connection.Close();
	}
}

Can anyone tell me the right way in connecting the database....

[b.ihde]

Hi again

I like to refer you to PsychoCoder´s SQL Basics in C# Tutorial

There you´ll find anything you need

regards

Ben

[PennyBoki]

OK I don't have much time, but in short here it is:

I'm not gonna give you the code directly... but you have't used your connection string.
You should not open the connection right away, you should use a try/catch/finally to do that and in the finally you should close the connection.
You do not use the ExecuteNonQuery() function when you are using a select statement, you should use that when you are using update,insert or delete.

Sorry... I don't have time..

[bunny20]

b.ihde ...I tried the code in psychocoder's tutorial

and i got an error. "no overload for method 'string' takes '0' arguments.

below is the code

 public static string GetConnectionString(string strConnection)
	{
		//variable to hold our connection string for returning it
		string strReturn = new string();
		//check to see if the user provided a connection string name
		
			//get the default connection string
			strReturn = ConfigurationManager.ConnectionStrings["testdatastring"].ConnectionString;
 
		//return the connection string to the calling method
		return strReturn;
	}

what does this mean?

[b.ihde]

The strReturn string expects an argument..

string strReturn = new string("teststring"); // 1 argument
string strReturn = new strin(); // 0 arguments

regards

Ben Ihde

This post has been edited by b.ihde: 13 January 2009 - 04:31 AM

[eclipsed4utoo]

bunny20, on 13 Jan, 2009 - 06:05 AM, said:

b.ihde ...I tried the code in psychocoder's tutorial

and i got an error. "no overload for method 'string' takes '0' arguments.

below is the code

 public static string GetConnectionString(string strConnection)
	{
		//variable to hold our connection string for returning it
		string strReturn = new string();
		//check to see if the user provided a connection string name
		
			//get the default connection string
			strReturn = ConfigurationManager.ConnectionStrings["testdatastring"].ConnectionString;
 
		//return the connection string to the calling method
		return strReturn;
	}

what does this mean?

there's really no need to use "new string()". use this:

string strReturn = string.Empty;