Related to data adapter

Question

What things are mandatory in connection object

Hemant Kumar · Answer

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 More · Answer

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

Related to data adapter

Answers (2)