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?

2311

---

What are the different cloud platforms?

949

---

What is an example of form?

982

---

Explain how insert record in the database?

1009

---

What is form application?

942

---

How many navigational features are provided by visual studio.net ide?

1024

---

Explain how many number of events does the timer controls?

915

---

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

902

---

What is form based application?

944

---

Explain the new events in textbox that has been included in vb?

946

---

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

949

---

What is a windows forms application?

956

---

What are controls in windows forms?

981

---

Name the property which is used to specify the source from where the crystal reports would be accessed.

966

---

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

1075

---