المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : cannot load data from database to textbox in Visual c# 2008



C# Programming
06-13-2009, 08:21 PM
Please help me on this code.
Am trying to load data from sql server 2005 express into textbox in visual c# 2008 express. I want the data to be displayed in the textbox from the first record in the database but am having this error message

"Ths best overload method match for 'system.data.sqlclient.sqlcommand.sqlcommand(string,system.data.sqlclient.sqlcommand)' has some invalid arguments.

Please help cos I dont know what to do about this.
Thanks

private void COMPANY_INFO_Load(object sender, EventArgs e)
{
btnAdd.Enabled = true;
btnCancel.Enabled = false;
btnUpdate.Enabled = true;
btnSave.Enabled = false;

SqlConnectionStringBuilder myBuilder = new SqlConnectionStringBuilder();
myBuilder.UserID = "sa";
myBuilder.Password = "admin123";
myBuilder.InitialCatalog = "Kay_Nylon_Db";
myBuilder.DataSource = "ADEMOLAPC";
myBuilder.ConnectTimeout = (30);

SqlConnection conn = new SqlConnection(myBuilder.ConnectionString);

SqlDataReader myReader = null;

SqlCommand myCommand = new SqlCommand("select * from Company_Info", myBuilder);

myReader = myCommand.ExecuteReader();
while (myReader.Read())
{

Console.WriteLine(myReader["Company_Id"].ToString());
Console.WriteLine(myReader["Company_Name"].ToString());
Console.WriteLine(myReader["Company_Address_Line1"].ToString());
Console.WriteLine(myReader["Company_Address_Line2"].ToString());
Console.WriteLine(myReader["Fax"].ToString());
Console.WriteLine(myReader["Email"].ToString());
}

}