a):-want to mark attendance on daily bases, so try to generate column on the behalf of same date.
b:) through sqlcommand I am able to generate column and also submitting the details.
c:) but getting problem when second employee came and mark attendance for the same date, so at that time I want to check in database if column already exit then go to else part, but this not happening for me.
d:) so any one please help me to get It right, by which we can check is column is exit in table or not?
string r = "";
protected void Button2_Click(object sender, EventArgs e)
{
string email2 = Convert.ToString(Session["emailid"]);
string date = DateTime.Now.ToString("dd");
string month = DateTime.Now.ToString("MMM");
string year = DateTime.Now.ToString("yyyy");
r = month + "_" + date + "_" + year;
SqlCo ...
Go to the complete details ...