User Profile

Collapse

Profile Sidebar

Collapse
HosseinKhoddami
HosseinKhoddami
Last Activity: Dec 25 '12, 06:31 PM
Joined: Dec 25 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • use Like this statement

    Code:
    string strQuery = "INSERT INTO Table1(FirstName , LastName , Age) Values ( '{0}' , '{1}' , {2} ) ";
    
    strQuery = string.Format(strQuery , txt_FirstName.Text , txt_LastName.Text , Convert.Toint32(txt_Age.Text));
    
    
    and Ten you can use strCommand in function like DoCommand(strQuery);
    
    
    using system.data.sqlclient; // imports sqlclient on top of your form or
    ...
    See more | Go to post
    Last edited by PsychoCoder; Dec 25 '12, 07:04 PM. Reason: Added code tags

    Leave a comment:


  • You can Write
    Select Table1.a , Table2.b
    From Table1 Inner join Table2
    on Table1.Fieldn = Table2.Fieldn


    in CommandText
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...