give me solution in c#

sarika sarikaa

for to add images in gridview column from mysql database.

private void Form2_Load(object sender, EventArgs e)

{

con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Admin\source\repos\DATABASE\data2.sql.mdf;Integrated Security=True;Connect Timeout=30");

con.Open();

adpt = new SqlDataAdapter("Select * from Details ", con);

dt = new DataTable();

adpt.Fill(dt);

dataGridView.DataSource = dt;

con.Close();

}

private void txtSearch_TextChanged(object sender, EventArgs e)

{

con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Admin\source\repos\DATABASE\data2.sql.mdf;Integrated Security=True;Connect Timeout=30");

con.Open();

adpt = new SqlDataAdapter(" select * from Details Where [Part No] like '%"+txtSearch.Text+"%'",con);

dt = new DataTable("Details");

adpt.Fill(dt);

dataGridView.DataSource = dt;

con.Close();

txtSearch.Width = 300;

txtSearch.Height = 70;

txtSearch.Font = new Font("Bold", 15,FontStyle.Bold);

}

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

sarika sarikaa8y ago
private void Form2_Load(object sender, EventArgs e)

{

con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Admin\source\repos\DATABASE\data2.sql.mdf;Integrated Security=True;Connect Timeout=30");

con.Open();

adpt = new SqlDataAdapter("Select * from Details ", con);

dt = new DataTable();

adpt.Fill(dt);

dataGridView.DataSource = dt;

DataGridViewImageCell imgcol = new DataGridViewImageCell();

dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;

dataGridView.RowTemplate.Height = 100;

dataGridView.AllowUserToAddRows = false;

DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();

imageColumn = (DataGridViewImageColumn)dataGridView.Columns[13];

imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;

con.Close();

}

BUT, IT SHOWS THE ERROR LIKE THIS:

System.InvalidCastException: 'Unable to cast object of type 'System.Windows.Forms.DataGridViewTextBoxColumn' to type 'System.Windows.Forms.DataGridViewImageColumn'.'
0

sarika sarikaa8y ago

varchar(MAX) in which i store the image path

Laxmidhar Sahoo8y ago

hello in which format you store the image like image converted byte or in varchar that is the path of the file

sarika sarikaa8y ago

i hav store image path in sqldatabase but it can't show imge in column of gridview.

please give me the c# coding about display image in gridview cell from sqldatabase .

Rajkiran Swain8y ago

public partial class _Default : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection();
protected void Page_Load(object sender, EventArgs e)
{
conn.ConnectionString
= "Data Source=MyServer; Integrated Security=True; database=test";
Load_GridData(); // call method below
}
void Load_GridData()
{
conn.Open(); // open the connection
SqlDataAdapter Sqa = new SqlDataAdapter("select * from picture", conn);
DataSet ds = new DataSet();
Sqa.Fill(ds); // fill the dataset
GridView1.DataSource = ds; // give data to GridView
GridView1.DataBind();
conn.Close();
}
}

Amit Kumar8y ago

Hi,

First get the image name from database and bind the gridview using image tag.

here is the a logical point if you store only image name in your database or whole path if

you store whole path of the image then it bind easily, if you store only image name then bind path hardcode in image tag and then bind your image name.

if you get whole path then use.

Height="80px" Width="100px" />

if you get only image name then use like.

Height="80px" Width="100px" />

Regards,

Amit

Laxmidhar Sahoo8y ago

private void Form2_Load(object sender, EventArgs e)

{

con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Admin\source\repos\DATABASE\data2.sql.mdf;Integrated Security=True;Connect Timeout=30");

con.Open();

adpt = new SqlDataAdapter("Select * from Details ", con);

ds = new Dataset();

adpt.Fill(ds);

dataGridView.DataSource = ds.tables[0];

con.Close();

}