Keyword not supported: 'datasource'.ERROR

Savita Joshi

15y12.7k.NET

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("@ID",SqlDbType.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!";
}

29 Replies

Know the answer? Post it — somebody with the same question will find it here.

Savita Joshi15y ago
@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 Yadav15y ago
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 Garad15y ago
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 Joshi15y ago
Hi all,

I dont think it has to do anything with the connection class ,anyways will upload it check it
Krishna Garad15y ago
Savita
why not it best to upload your connection.cs file here? Then we can check it.
Blocked Account15y ago
Hi savita,

just attach your code here.
Savita Joshi15y ago
@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 Nair15y ago
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 Joshi15y ago
@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 Nair15y ago
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 Garad15y ago
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(""@ID",SqlDbType.Int");
Param[0].Value=TextBox1.Text;
// Create all parameter with value and now call ExecuteCommand Method
Connection.ExecuteCommand("Sql Statement",Param);//Write Insert Query insted of Sql Statement here.
Mayur Gujrathi15y ago
query resolved?
Krishna Garad15y ago
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 Joshi15y ago
@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 Garad15y ago
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 Joshi15y ago
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 Garad15y ago
just upload your connection class here i'll check it.
Savita Joshi15y ago
@Krishna,

I have declared db,cmd which are sqlconnection object and sqlcommand object respectively outside the connect method using public modifier..
Krishna Garad15y ago
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 Joshi15y ago
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 Garad15y ago
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 Joshi15y ago
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 Garad15y ago
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 Joshi15y ago
"Datasource=om;Initial Catalog=student;Integrated security=true";
Krishna Garad15y ago
Paste your connection string Here.
Savita Joshi15y ago
@krishna

really did not get wat u r speaking!!!!!!!!!!!!!
Krishna Garad15y ago
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 Joshi15y ago
@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 Garad15y ago
In your connection string Separate DataSource like
"Data Source=servername;user id=;password=;Database=DB"

Keyword not supported: 'datasource'.ERROR

Keyword not supported: 'datasource'.

ExecuteNonQuery: Connection property has not been initialized