int ScriptId = 0; string sql = "Select Max(ScriptId) as ScriptId from tbl_Script"; SqlCommand cmd = new SqlCommand(sql, connection); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); if (reader.HasRows) { while (reader.Read()) { if (reader["ScriptId"] == System.DBNull.Value) { ScriptId = 1; } else { ScriptId = ScriptId++; } } }
if (reader["ScriptId"] == System.DBNull.Value)
reader[0]
ScriptId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)