|
![](/images/resource/spacer.gif) |
|
datagridview default error dialog c# แก้ยังไงครับผม |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
ปัญหา มันคือ insert ลง Access เข้า Type เป็น long binary data แต่เอาออกให้มัน โชว์ใน Datagridview ได้ ติด Error ตามรูปเลย ครับ
Code (C#) อันนี้คือปุ่น insert ของผม
private void insert_Click(object sender, EventArgs e)
{
try
{
byte[] image = null;
FileStream fs = new FileStream(pic, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
image = br.ReadBytes((int)fs.Length);
string sql = "insert into Disdurse_Expose(ID,Dis_date,Dis_Id,Dis_pay,Dis_list,Dis_amount,Date_recive_send,Dis_recipients,Dis_senders,Dis_remarks,Dis_photo) VALUES(@ID,@Dis_date,@Dis_Id,@Dis_pay,@Dis_list,@Dis_amount,@Date_recive_send,@Dis_recipients,@Dis_senders,@Dis_remarks,@Dis_photo)";
if (con.State != ConnectionState.Open) con.Open();
cmd = new OleDbCommand(sql, con);
cmd.Parameters.Add(new OleDbParameter("@ID",txt1.Text));
cmd.Parameters.Add(new OleDbParameter("@Dis_date",date1.Value.ToLongDateString()));
cmd.Parameters.Add(new OleDbParameter("@Dis_Id",txt2.Text));
cmd.Parameters.Add(new OleDbParameter("@Dis_pay",txt3.Text));
cmd.Parameters.Add(new OleDbParameter("@Dis_list",txt4.Text));
cmd.Parameters.Add(new OleDbParameter("@Dis_amount",txt5.Text));
cmd.Parameters.Add(new OleDbParameter("@Date_recive_send",date2.Value.ToLongDateString()));
cmd.Parameters.Add(new OleDbParameter("@Dis_recipients",txt6.Text));
cmd.Parameters.Add(new OleDbParameter("@Dis_senders",txt7.Text));
cmd.Parameters.Add(new OleDbParameter("@Dis_remarks",txt8.Text));
cmd.Parameters.Add(new OleDbParameter("@Dis_photo",pic));
int x = cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show(x.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
Code (C#) ในส่วนของ Datagridview
con.Open();
DataTable dt = new DataTable();
adap = new OleDbDataAdapter("select * from Disdurse_Expose", con);
adap.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
ติด Error
![datagridview default error dialog datagridview default error dialog](https://www.thaicreate.com/upload/stock/20160926205000.png?v=1001)
Tag : .NET, Ms Access, Win (Windows App), C#, Windows
![](/images/adv.jpg?v=1001)
|
ประวัติการแก้ไข 2016-09-26 22:20:13
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2016-09-26 20:51:33 |
By :
snowman0020 |
View :
2904 |
Reply :
5 |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
เก็บรูปเป็น path ไม่ง่ายกว่ารึครับ
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2016-09-26 22:45:28 |
By :
lamaka.tor |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
ถ้าเก็บเป็น Path จะเรียกดูข้อมูลได้ไหม ครับ ค้นหาจากรหัสแล้วโชว์รูป
ใน picturebox ก็อ่านเกี่ยวกับ picturebox
ถ้าโชว์ใน datagrid ก็อ่านเกี่ยวกับ datagrid
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2016-09-27 08:29:29 |
By :
lamaka.tor |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
|
|
|
![](/images/digitalocean-banner.jpg)
|
Load balance : Server 00
|