//- Fetch Data from SQL Database NetstairODBC.SQLDBC oDB = new NetstairODBC.SQLDBC(); DataTable dt = oDB.SQLDataTable("SELECT * FROM tblTableGoesHereName"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { //- Process record } } dt.Clear(); oDB.Dispose(); //- Insert data into SQL Database Table NetstairODBC.SQLDBC oDB = new NetstairODBC.SQLDBC(); int iRecordAffected = oDB.SQLExecute("INSERT INTO tblTableName(first.last) VALUES('John','Doe')); oDB.Dispose();
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add support@netstaircom.net to your trusted senders list in your email software.