Related to data adapter

Normally for Connecting to database we want the following things
1. ConnectionString
2. Connection Object
3. DataAdapter
4. To Store Data we need DataSet
e.t.c
Please see this example like this you need to write
public string SaveData(string firstName, string lastName)
    {
        try
        {
            String connectionString = ConfigurationManager.ConnectionStrings["TESTDB"].ConnectionString;
            string result = Boolean.FalseString;
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = connection;
                cmd.CommandText = String.Format("insert into Hemanth_DB.dbo.PersonName(FirstName,LastName) values ('{0}','{1}')", firstName, lastName);
                //cmd.CommandText = "insert into Hemanth_DB.dbo.PersonName(FirstName,LastName) values (@FirstName,@LastName)";
                //cmd.Parameters.Add(new SqlParameter("@FirstName", firstName));
                //cmd.Parameters.Add(new SqlParameter("@LastName", lastName));

                cmd.CommandType = CommandType.Text;
                connection.Open();
                int count = cmd.ExecuteNonQuery();
                if (count > 0)
                {
                    result = Boolean.TrueString;
                }
                else
                {
                    result = Boolean.FalseString;
                }
            }
            return result;
        }
        catch (Exception exp)
        {
            return exp.Message;
        }

    }

2 Replies

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

Hemant Kumar15y ago
Normally for Connecting to database we want the following things
1. ConnectionString
2. Connection Object
3. DataAdapter
4. To Store Data we need DataSet
e.t.c
Please see this example like this you need to write
public string SaveData(string firstName, string lastName)
    {
        try
        {
            String connectionString = ConfigurationManager.ConnectionStrings["TESTDB"].ConnectionString;
            string result = Boolean.FalseString;
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = connection;
                cmd.CommandText = String.Format("insert into Hemanth_DB.dbo.PersonName(FirstName,LastName) values ('{0}','{1}')", firstName, lastName);
                //cmd.CommandText = "insert into Hemanth_DB.dbo.PersonName(FirstName,LastName) values (@FirstName,@LastName)";
                //cmd.Parameters.Add(new SqlParameter("@FirstName", firstName));
                //cmd.Parameters.Add(new SqlParameter("@LastName", lastName));

                cmd.CommandType = CommandType.Text;
                connection.Open();
                int count = cmd.ExecuteNonQuery();
                if (count > 0)
                {
                    result = Boolean.TrueString;
                }
                else
                {
                    result = Boolean.FalseString;
                }
            }
            return result;
        }
        catch (Exception exp)
        {
            return exp.Message;
        }

    }
Pravin More15y ago
hi,
I think DataSource,UserID,Passward are mandatory....
but i think this may vary depend on type of connection and database....

Thanx,
Pravin.