public DataSet GetARecord(int index){ //code for output parameter of a stored procedure //stored procedure returnex EmpIdex(PK), Name, address, LastUpdatedTime(old Time) . . . . //code to store the LastUpdatedTime da.Fill(ds, "Employee"); return ds; }
public DataSet GetARecord(int index){ //code for output parameter of a stored procedure . . . . //I have to store the LastUpdatedTime: "paramDateTime" is SQLParameter declared globally paramDateTime = da.UpdateCommand.Parameters.Add("@PUpdatedTimeOLD", SqlDbType.DateTime, 8, "UpdatedTime"); paramDateTime.SourceVersion = DataRowVersion.Original; da.Fill(ds); return ds; }
paramDateTime = da.UpdateCommand.Parameters.Add("@PUpdatedTimeOLD", SqlDbType.DateTime, 8, "UpdatedTime"); paramDateTime.SourceVersion = DataRowVersion.Original;
public void UpdateEmployee(DataSet ds){ //write code to add parameters, EmpIndex(PK), Name, Address, LastUpdateTime(Old Time) . . . //calling DataAdapter's update() da.Update(ds."Employee");}