Interested to Buy Any Domain ? << Click Here >> for more details...
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 This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is formdata?
Which command prompt utility is used to convert a resource file from the text format into the binary format?
Explain how many number of events does the timer controls?
What is the use of runworkasync() methods?
how see report periviwe
What is the difference between desktop application and windows application?
Name the property which is used to specify the source from where the crystal reports would be accessed.
Explain the new events in textbox that has been included in vb?
Explain the difference between listbox and combo box?
Suppose I have two combobox .. And I have some items in both combobox now I need to check the item in both combobox if same item is present in both combobox I need to display that item in message box?
What is form description?
How will calculated the net amount in tax add like total net amount = LT+ST+CESS+amount 2500 = 10%+12.5%+5.15%+amount? kindly please explain what type of formula we apply in software? Tushar
What is the extension of a compiled help project file?
How save rerecord in the database?
What is form design?
