-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Gnana
Message 4 in Discussion
Here is the sample working code.
SqlConnection objConnection = new SqlConnection
("Server=3.74.5.72;Uid=apuser;Pwd=s1tart;Database=apepayc01");
SqlCommand objCommand = new SqlCommand();
string SQL = "select cust_seq,legacy_org_id,cust_name from
t_ep_customer";
objConnection.Open();
SqlDataAdapter objAdapter = new
SqlDataAdapter(SQL,objConnection);
DataSet ds1 = new DataSet();
objAdapter.Fill(ds1,"customer");
dataGrid1.DataSource = ds1.Tables["customer"];
dataGrid1.Width = 500 ;
dataGrid1.Height = 500;
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = "customer";
DataGridColumnStyle cs = new DataGridTextBoxColumn();
cs.MappingName ="cust_name";
cs.Width= 400;
ts.GridColumnStyles.Add(cs);
dataGrid1.TableStyles.Add(ts);
Good luck
Gnana
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
