locked
data control RRS feed

  • Question

  • data insert update select delete for normalize realational table which is the right sql command  
    Wednesday, September 2, 2015 3:17 PM

Answers

  • Hi benjir01,

    Could you please description your problem more clear? 

    Do you want to ask how to write sql statement? Code below is for your reference.

    select column1,column2 from table1
    insert into table1(column1,column2) values(value1,value2)
    update table1 set column1 = value1, column2 = value2
    delete from table1 where column1 = value1

    Do you want to ask how to process data in winform? You could reference below links.
    https://msdn.microsoft.com/en-us/data/jj682076.aspx?f=255&MSPPError=-2147217396

    Best Regards,
    Li Wang

    • Proposed as answer by Youjun Tang Tuesday, September 8, 2015 9:29 AM
    • Marked as answer by Youjun Tang Thursday, September 10, 2015 2:23 AM
    Thursday, September 3, 2015 3:00 AM