Hi,droiddeve
I have modified your code please refer the below.
C#
public void BindGrid()
{
var connectionString = ConfigurationManager.ConnectionStrings["Constr"].ConnectionString;
// SqlDataReader myreader;
SqlConnection con = new SqlConnection();
con = new SqlConnection(connectionString);
{
using (SqlCommand cmd = new SqlCommand("SelectFromTbl_StudentRegistration_TOGRID ", con))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
try
{
sda.Fill(dt);
dataGridView1.DataSource = null;
dataGridView1.Columns.Clear();
dataGridView1.Rows.Clear();
dataGridView1.ColumnCount = 50;
//Set AutoGenerateColumns False
//Set AutoGenerateColumns False
dataGridView1.AutoGenerateColumns = false;
//Set Columns Count
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
DataGridViewCell Edit = dataGridView1.Rows[0].Cells[0];
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit And Delete ";
Editlink.LinkBehavior = LinkBehavior.HoverUnderline;
Editlink.Text = "Edit OR Delete";
dataGridView1.Columns.Insert(0, Editlink);
foreach (DataGridViewRow rows in dataGridView1.Rows)
{
byte[] data = (byte[])dt.Rows[1]["Student_Image"];
MemoryStream ms = new MemoryStream(data);
DataGridViewImageColumn imageCol = new DataGridViewImageColumn();
DataGridViewImageCell cell = dataGridView1.Rows[0].Cells[1] as DataGridViewImageCell;
//imageCol.ImageLayout = DataGridViewImageCellLayout.NotSet;
imageCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
imageCol.HeaderText = "image";
dataGridView1.Columns.Insert(1, imageCol);
imageCol.Image = Image.FromStream(ms);
}
//dataGridView1.Columns[2].DataPropertyName = dt.Columns["Student_Reg_No"].ToString();
dataGridView1.Columns[2].HeaderText = "REGISTRATION NO";
dataGridView1.Columns[2].DataPropertyName = "Student_Reg_No";
dataGridView1.Columns[2].ReadOnly = true;
dataGridView1.Columns[3].HeaderText = "ADM NO";
dataGridView1.Columns[3].DataPropertyName = "ADM_NO";
dataGridView1.Columns[3].ReadOnly = true;
dataGridView1.Columns[4].HeaderText = "STUDENT NAME";
dataGridView1.Columns[4].DataPropertyName = "Student_Name";
dataGridView1.Columns[4].ReadOnly = true;
dataGridView1.Columns[5].HeaderText = "FATHERS NAME";
dataGridView1.Columns[5].DataPropertyName = "Fathers_Name";
dataGridView1.Columns[5].ReadOnly = true;
dataGridView1.Columns[6].HeaderText = "DOB";
dataGridView1.Columns[6].DataPropertyName = "Student_DOB";
dataGridView1.Columns[6].ReadOnly = true;
dataGridView1.Columns[7].HeaderText = "CLASS";
dataGridView1.Columns[7].DataPropertyName = "Class";
dataGridView1.Columns[7].ReadOnly = true;
dataGridView1.Columns[8].HeaderText = "SECTION";
dataGridView1.Columns[8].DataPropertyName = "Section";
dataGridView1.Columns[8].ReadOnly = true;
dataGridView1.Columns[9].HeaderText = "GENDER";
dataGridView1.Columns[9].DataPropertyName = "Gender";
dataGridView1.Columns[9].ReadOnly = true;
dataGridView1.Columns[10].HeaderText = "RELIGION";
dataGridView1.Columns[10].DataPropertyName = "Religion";
dataGridView1.Columns[10].ReadOnly = true;
dataGridView1.Columns[11].HeaderText = "OTHER RELIGION";
dataGridView1.Columns[11].DataPropertyName = "otherReligion";
dataGridView1.Columns[12].HeaderText = "CASTE";
dataGridView1.Columns[12].DataPropertyName = "Caste";
dataGridView1.Columns[13].HeaderText = "STUDENTADRESS";
dataGridView1.Columns[13].DataPropertyName = "StudentAdress";
dataGridView1.Columns[14].HeaderText = "STATE";
dataGridView1.Columns[14].DataPropertyName = "State";
dataGridView1.Columns[15].HeaderText = "CITY";
dataGridView1.Columns[15].DataPropertyName = "City";
dataGridView1.Columns[16].HeaderText = "ADHAR NO";
dataGridView1.Columns[16].DataPropertyName = "AdharNo";
dataGridView1.Columns[17].HeaderText = "EMERGENCEY CONTACT NAME";
dataGridView1.Columns[17].DataPropertyName = "InCaseOfEmgName";
dataGridView1.Columns[18].HeaderText = "RELATION";
dataGridView1.Columns[18].DataPropertyName = "Relation";
dataGridView1.Columns[19].HeaderText = "Emg.Phone NO";
dataGridView1.Columns[19].DataPropertyName = "Emg_PhoneNo";
dataGridView1.Columns[20].HeaderText = "Emg.MOB NO";
dataGridView1.Columns[20].DataPropertyName = "Emg_MobNo";
dataGridView1.Columns[21].HeaderText = "Emg.Address";
dataGridView1.Columns[21].DataPropertyName = "Emg_Adress";
dataGridView1.Columns[22].HeaderText = "CAT";
dataGridView1.Columns[22].DataPropertyName = "Student_Cateogary";
dataGridView1.Columns[23].HeaderText = "FATHER DOB";
dataGridView1.Columns[23].DataPropertyName = "FathersDOB";
dataGridView1.Columns[24].HeaderText = "FATHER CONTACTNO";
dataGridView1.Columns[24].DataPropertyName = "FathersMobNo";
dataGridView1.Columns[25].HeaderText = "FATHER PROFESSION";
dataGridView1.Columns[25].DataPropertyName = "FathersProfession";
dataGridView1.Columns[26].HeaderText = "FATHER DESIGNATION";
dataGridView1.Columns[26].DataPropertyName = "FathersDesignation";
dataGridView1.Columns[27].HeaderText = "FATHER INCOME";
dataGridView1.Columns[27].DataPropertyName = "FatherAnnualincome";
dataGridView1.Columns[28].HeaderText = "FATHERS EMAIL";
dataGridView1.Columns[28].DataPropertyName = "FathersEmail";
dataGridView1.Columns[29].HeaderText = "FATHER REGIDENCE ADD";
dataGridView1.Columns[29].DataPropertyName = "FathersResAdss";
dataGridView1.Columns[30].HeaderText = "FATHER OFF ADD";
dataGridView1.Columns[30].DataPropertyName = "FathersOffAdd";
dataGridView1.Columns[31].HeaderText = "MOTHER NAME";
dataGridView1.Columns[31].DataPropertyName = "Mothers_Name";
dataGridView1.Columns[32].HeaderText = "MOTHER DOB";
dataGridView1.Columns[32].DataPropertyName = "MothersDOB";
dataGridView1.Columns[33].HeaderText = "MOTHER MOB NO";
dataGridView1.Columns[33].DataPropertyName = "MothersMobNo";
dataGridView1.Columns[34].HeaderText = "MOTHER PROFESSION";
dataGridView1.Columns[34].DataPropertyName = "MothersProfession";
dataGridView1.Columns[35].HeaderText = "MOTHER DEG.";
dataGridView1.Columns[35].DataPropertyName = "MothersDesignation";
dataGridView1.Columns[36].HeaderText = "MOTHER INCOME";
dataGridView1.Columns[36].DataPropertyName = "MothersAnnualIncome";
dataGridView1.Columns[37].HeaderText = "MOTHER EMAIL";
dataGridView1.Columns[37].DataPropertyName = "MothersEmail";
dataGridView1.Columns[38].HeaderText = "MOTHER ADD";
dataGridView1.Columns[38].DataPropertyName = "MotherResAdd";
dataGridView1.Columns[39].HeaderText = "MOTHER OFFICE ADD";
dataGridView1.Columns[39].DataPropertyName = "MothersOffAdd";
dataGridView1.Columns[40].HeaderText = "BLOOD GROUP";
dataGridView1.Columns[40].DataPropertyName = "BloodGroup";
dataGridView1.Columns[41].HeaderText = "HEIGHT";
dataGridView1.Columns[41].DataPropertyName = "height";
dataGridView1.Columns[42].HeaderText = "WEIGHT";
dataGridView1.Columns[42].DataPropertyName = "Weight";
dataGridView1.Columns[43].HeaderText = "FAMILY DOC";
dataGridView1.Columns[43].DataPropertyName = "FamilyDoc";
dataGridView1.Columns[44].HeaderText = "ALLERGY DES";
dataGridView1.Columns[44].DataPropertyName = "AllergyMedDesc";
dataGridView1.Columns[45].HeaderText = "MEDICAL ADDRESS";
dataGridView1.Columns[45].DataPropertyName = "MedicalAdress";
dataGridView1.Columns[46].HeaderText = "SMS SENDER NAME";
dataGridView1.Columns[46].DataPropertyName = "SmsSenderName";
dataGridView1.Columns[47].HeaderText = "SMS EMAIL ADD";
dataGridView1.Columns[47].DataPropertyName = "SmsDetailEmail";
dataGridView1.Columns[48].HeaderText = "SMS DETAIL MOB.NO";
dataGridView1.Columns[48].DataPropertyName = "SmsDetailMobNo";
dataGridView1.Columns[49].HeaderText = "ALTERNATE MOB.NO";
dataGridView1.Columns[49].DataPropertyName = "SmsDetailAltMobNo";
dataGridView1.DataSource = dt;
}
catch (Exception)
{
MessageBox.Show("Connection Not Establish");
}
}
}
}
}
}