Hi,
ttry this
DataRow[] oImportMinRowRestrictions;
szExpression="HotelXid="+iPid;
oImportMinRowRestrictions =
dsHotelDetails.Tables[0].Select(szExpression);
Thanks
Vipin
On Wed, Jun 2, 2010 at 8:12 PM, Gururaj Balagar <[email protected]>wrote:
>
>
> On 5/30/10, Puspa <[email protected]> wrote:
>>
>> Hi All,
>> I need to check data inside the table of sql server.If the data
>> exist,it show the existence of data.Actually i used for loop for
>> checking,
>> but it didn't give proper result.so i need help from u that how to
>> check exist data in sql server using dataset?I need coding in c#.
>>
>> Thanks in advance
>
>
> I have given 2 example check
> You can use foreach loop
>
>
> * Looping over DataTable instance (C#) ---*
>
> using System;
> using System.Data;
>
> class Program
> {
> static void Main()
> {
> DataTable table = *GetTable()*; *// Get the data table.*
> foreach (DataRow row in table.*Rows*) *// Loop over the rows.*
> {
> Console.WriteLine("--- Row ---"); *// Print separator.*
> foreach (var item in row.*ItemArray*) *// Loop over the items.*
> {
> Console.Write("Item: "); *// Print label.*
> Console.WriteLine(item); *// Invokes ToString abstract
> method.*
> }
> }
> Console.Read(); *// Pause.*
> }
>
> */// <summary>
> /// Generates DataTable filled with patient information.
> /// </summary>*
> static DataTable *GetTable()*
> {
> DataTable table = new *DataTable*(); *// New data table.*
> table.Columns.Add("Dosage", typeof(int)); *// Add five columns.*
> table.Columns.Add("Drug", typeof(string));
> table.Columns.Add("Patient", typeof(string));
> table.Columns.Add("Date", typeof(DateTime));
> table.Rows.Add(15, "Abilify", "Jacob", DateTime.Now); *// Add five
> data rows.*
> table.Rows.Add(40, "Accupril", "Emma", DateTime.Now);
> table.Rows.Add(40, "Accutane", "Michael", DateTime.Now);
> table.Rows.Add(20, "Aciphex", "Ethan", DateTime.Now);
> table.Rows.Add(45, "Actos", "Emily", DateTime.Now);
> return table; *// Return reference.*
> }
> }
>
>
> this is console program
>
> *class *MainClass
> {
> *static **void *Main(string[] args)
> {
> string connString = @
> "server = .\sqlexpress;integrated security = true;database = northwind";
> string sql = @
> "select productname,unitprice from products where unitprice < 20";
> SqlConnection conn = *new *SqlConnection(connString);
> *try*
> {
> conn.Open();
> SqlDataAdapter da = *new *SqlDataAdapter(sql, conn);
> DataTable dt = *new *DataTable();
> da.Fill(dt);
> foreach (DataRow row in dt.Rows)
> {
> foreach (DataColumn col in dt.Columns)
> Console.WriteLine(row[col]);
> }
> }
> *catch*(Exception e)
> {
> Console.WriteLine("Error: " + e);
> }
> *finally*
> {
> conn.Close();
> }
> }
> }
>
>
--
"People who never make mistakes, never do anything."
dEv
