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

2549

---

Explain something about crystal report in brief?

1013

---

What is window form application?

1003

---

Explain the difference between listindex and tab index?

1116

---

Which property of the progressbar control specifies the amount to increment the current value of the control?

1145

---

how see report periviwe

2764

---

Are windows forms still used?

1125

---

how print PGL by XML

3046

---

Explain how insert record in the database?

1076

---

What is the difference between a document and a form?

1059

---

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?

1044

---

Explain about crystal report in brief?

997

---

Can you create a tabletype of recordset in Jet - connected ODBC dbengine?

2320

---

What are the forms of database?

1020

---

Explain how save rerecord in the database?

1041

---