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);

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

2266

---

What is form and meaning?

861

---

What is the difference between pixels, points, and em’s when fonts are displayed?

982

---

Where to use new keyword other than create instance?

1070

---

How do I change the console application in windows?

942

---

Is windows an application software?

956

---

What is the use of form?

871

---

Name the property which of menu cannot be set at run time?

1032

---

Explain how barcode create in the report?

913

---

how print PGL by XML

2948

---

Explain the difference between listbox and combo box?

910

---

Name the method that has to be overridden to change the appearance of the control that is inherited from an existing control.

909

---

What is a windows form application?

929

---

What is form description?

964

---

What is the difference between desktop application and windows application?

947

---