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(FirstNameLastName) values ('{0}''{1}') firstName lastName); //cmd.CommandText = insert into Hemanth_DB.dbo.PersonName(FirstNameLastName) 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 DataSourceUserIDPassward are mandatory.... but i think this may vary depend on type of connection and database.... Thanx Pravin.