Keyword not supported: 'datasource'.ERROR

Question

Hi friends Keyword not supported: 'datasource'. The code behind for a button click is as below: protected void Button1_Click(object sender EventArgs e) { obj.connect(); obj.cmd.Parameters.Add(@IDSqlDbType.Int).Value=TextBox1.Text; obj.cmd.Parameters.Add(@Password SqlDbType.VarChar).Value = TextBox2.Text; obj.cmd.Parameters.Add(@ConfirmPassword SqlDbType.VarChar).Value = TextBox3.Text; obj.cmd.Parameters.Add(@Email SqlDbType.VarChar).Value = TextBox4.Text; obj.cmd = new SqlCommand(submitrecord); obj.cmd.ExecuteNonQuery(); obj.db.Close(); Label l1 = new Label(); l1.Text = Record has been submitted!; }

Savita Joshi · Answer

@Krishna r u not comfortable using vb.net? OK i will convert the class to c# and upload. Just syntax is slightly different right!!!!!!!

Vijay Yadav · Answer

Hi Savita Just try this: Dim con As New SqlConnection Dim cmd As New SQlCommand Con.ConnectionString=Data Source=;Initial Catalog=;Integrated Security=True con.Open() cmd.CommandText = INSERT into tblCustomer(title firstname) Values ( & title &    & firstname & ) cmd.Connection=con cmd.ExecuteNonQuery() con.Close()

Krishna Garad · Answer

Above you are using C# and uploading Vb.Net file what's this. It's also ok but where is the method in your class to execute the method only in connect method you are executing the command. Anyway whatever it is use this class uploaded here.

Savita Joshi · Answer

Hi all I dont think it has to do anything with the connection class anyways will upload it check it

Krishna Garad · Answer

Savita why not it best to upload your connection.cs file here? Then we can check it.

Manish Dwivedi · Answer

Hi savita just attach your code here.

Savita Joshi · Answer

@Suthish I checked it the way u said but the problem is still there.. ie ExecuteNonQuery: Connection property has not been initialized.I am getting this error now.. Please help

Suthish Nair · Answer

If you are saying your code is correct then why its not working? We trying to help you but you not trying to help yourself. Put breakpoint debug each line and check where its getting failed. After obj.connect() check your connection is working or not. For example: using ( SqlConnection con = new SqlConnection ()) { if ( con.State == ConnectionState.Open ) { } }

Savita Joshi · Answer

@Suthish If u check the above posts i have written the connection class(ie i have separate class for connection who`s object i create and use it in all pages) and used it where all want it..

Suthish Nair · Answer

Savita First of all there is no connection opened for you logic to work. how to find actual connection string Find Database Connection and Generate Connection String using Visual Studio this article help how to use connection and command. DataGridView - Insert Update Delete and Retrieve records using stored procedure

Krishna Garad · Answer

Write this one more method in your connection class. public static void ExecuteCommand(string _command SqlParameter[]Param) { try { cn.Open(); cmd = new SqlCommand(_command cn); foreach (SqlParameter p in Param) { cmd.Parameters.Add(p); } cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { cn.Close(); } } wirte the code in your button_click event like bellow Connection.Connect(); SqlParameter[] Param=new SqlParameter[4];//Size is variable depends on requirement. Param[0]=new SqlParameter( @IDSqlDbType.Int); Param[0].Value=TextBox1.Text; // Create all parameter with value and now call ExecuteCommand Method Connection.ExecuteCommand(Sql StatementParam);//Write Insert Query insted of Sql Statement here.

Mayur Gujrathi · Answer

query resolved?

Krishna Garad · Answer

It's giving error for command object. Implement your connection class with different method ex. for connect command stored procedure etc... and while accessing the class access the method with classname ex. Connection.Connect();

Savita Joshi · Answer

@Krishna Earlier tried the same way but its still not working.. It gives the error i mentioned ExecuteNonQuery: Connection property has not been initialized.I am getting this error now

Krishna Garad · Answer

Write your connection class like bellow it's corking I've tested it. public static class Connection { static SqlConnection cn; static SqlCommand cmd; static SqlDataReader dr; public static void Connect() { string connstring = Data source=SHRINIVAS;Initial Catalog=test;Integrated security=true; cn = new SqlConnection(connstring); cn.Open(); } //write seperate method for command object like above public static void Command(string _sql) { //implement for command } }

Savita Joshi · Answer

Hmmm THIS IS THE CONNECTION CLASS using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient; /// /// Summary description for data /// public class data { public SqlConnection db; public SqlCommand cmd; public SqlDataReader dtr; public string str; public data() { // // TODO: Add constructor logic here // } public void connect() { str = Data source=test;Initial Catalog=test;Integrated security=true; db = new SqlConnection(str); db.Open(); cmd = new SqlCommand( db); } }

Krishna Garad · Answer

just upload your connection class here i'll check it.

Savita Joshi · Answer

@Krishna I have declared dbcmd which are sqlconnection object and sqlcommand object respectively outside the connect method using public modifier..

Krishna Garad · Answer

write your connect method like bellow Public void connect() { string str=Data source=om;initial catalog=test;integrated security=true; SqlConnection cn=new SqlConnection(str);//here was the error. cn.Open() //cmd=new sqlcommand(db); }

Savita Joshi · Answer

Hi ExecuteNonQuery: Connection property has not been initialized.I am getting this error now.. Please help @Krishna Public sqlconnection db; Public sqlcommand cmd; Public void connect() { string str=Data source=om;initial catalog=test;integrated security=true; db=new sqlconnection(str); db.open(); cmd=new sqlcommand(db); } This is the connect method...

Krishna Garad · Answer

code is ok. can you give your connect method. or try to initialize SqlConnection class in your connect method like connect() { SqlConnection conn=new SqlConnection(ConnectionString); }

Savita Joshi · Answer

Oh dats a silly mistake.. thanks for pointing out I have created stored procedure... Is that code correct???? i am still getting this error now: ExecuteNonQuery: Connection property has not been initialized

Krishna Garad · Answer

Ya I'm right. Write your connection string like bellow now. Data source=om;Initial Catalog=student;Integrated security=true; Check what I've done change in your original connection string.

Savita Joshi · Answer

Datasource=om;Initial Catalog=student;Integrated security=true;

Krishna Garad · Answer

Paste your connection string Here.

Savita Joshi · Answer

@krishna really did not get wat u r speaking!!!!!!!!!!!!!

Krishna Garad · Answer

Write Seperate class for connection is not what i want. I want correct your connection string attribute. not DataSource write Data Source. Give the space between Data and Source.

Savita Joshi · Answer

@Krishna I have a separate connection class.. I am creating object obj of that connection class and using its method to connect to database..

Krishna Garad · Answer

In your connection string Separate DataSource like Data Source=servername;user id=;password=;Database=DB