Answer Posted / venky

Dear friend my answer is relating to csharp.net....SQLSERVER Database.

TO get records from database

1) our Application have to Connect with database.

SQlconnection cn=new sqlconnectio(@"server=.\SQLEXPRESS;Database=mydatabase;Integrated Security=SSPI");
cn.open();

2) we have to prepare COMMAND object Which encapsulate a sql statement and connection obj.


SQLCommand cmd=new Sqlcommand("select * from table1",cn);

then we call following method to get records

SqlDataReader rdr= cmd.ExecuteReader(CommandBehavior.CloseConnection);
int f_cnt= rdr.FieldCount;
Type t= rdr.GetFieldType(1);

while(rdr.Read())
{
int cou = rdr.FieldCount;
for(int i1=0;i1<cou;i1++)
{


string s2 = rdr.GetValue(i1).ToString();
ans = ans + " " + s2+" ";


}
i++;
ans = ans + "\n";

}
MessageBox.Show(ans);

Is typeform free?

970

---

Which template creates a .net compact framework 2.0 forms application for pocket pc 2003 and later?

1006

---

What are controls in windows forms?

1049

---

Explain how insert record in the database?

1071

---

How do I change the console application in windows?

1058

---

Which command prompt utility is used to convert a resource file from the text format into the binary format?

1116

---

How to create a set up in vb.net for desktop application please say steps with examples?

1010

---

What is form based application?

1006

---

What is form technology?

1000

---

What is the synonym of form?

944

---

What are the forms of database?

1014

---

Name the event that enables the user to prevent shifting of focus from control until all the validation rules have been met.

964

---

Which window allows viewing the resources of the servers, such as services, processes and the event log?

1045

---

How do you apply specific formatting to the data inside the cells?

2380

---

Which property of the errorprovider control automatically sets to the form to which?

1014

---