ต้่องการ Binding รุปที่เก็บในฐานข้อมูลลง Picturebox และ DataGridview ครับ
Code (VB.NET) Private Sub SET_IMG()
Dim fs As FileStream
fs = New FileStream(OpenFileDialog1.FileName.ToString(), IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.Read)
fsimage = New Byte(CInt(fs.Length)) {}
fs.Read(fsimage, 0, CInt(fs.Length))
fs.Close()
End Sub
Code (VB.NET) da1 = New OdbcDataAdapter("SELECT * from UNLASSET ORDER BY ASSET_CODE desc", cn)
da1.Fill(ds, "UNLASSET")
BsHeader.DataMember = "UNLASSET"
BsHeader.DataSource = ds
txtDOC_CODE.DataBindings.Add("text", BsHeader, "ASSET_CODE")
Dim bind_doc_date As New Binding("Value", BsHeader, "DATE_ADD")
AddHandler bind_doc_date.Format, AddressOf DTFormatter
AddHandler bind_doc_date.Parse, AddressOf DTParser
dtpdoc_date.DataBindings.Add(bind_doc_date)
cbType.DataBindings.Add("text", BsHeader, "TYPE")
txtCode.DataBindings.Add("text", BsHeader, "CODE")
txtSerialNO.DataBindings.Add("text", BsHeader, "SERIAL_NO")
txtDetail.DataBindings.Add("text", BsHeader, "DETAIL")
cbTenant.DataBindings.Add("text", BsHeader, "TENANT")
cbAddress.DataBindings.Add("text", BsHeader, "ADDRESS")
picAsset.DataBindings.Add(New Binding("image", BsHeader, "PIC", True))
txt_DOC_STATUS.DataBindings.Add("text", BsHeader, "STATUS")
DataGridView1.DataSource = ds
DataGridView1.DataMember = "UNLASSET"
DataGridView1.DataMember = "UNLASSET"
BindingNavigator1.BindingSource = BsHeader
Tag .NET, Ms SQL Server 2008, VBScript, Crystal Report, Win (Windows App), VS 2008 (.NET 3.x)
Date :
2013-11-13 15:40:51By :
kwanamnatView :
885Reply :
1
อยากได้เหมือนกันครับ Code (C#) private void frmIMOselected_Load(object sender, EventArgs e)
{
for (int i = 0; i < tblIMODataGridView.RowCount-1 ; i++)
{
dataGridView1.Rows.Add(tblIMODataGridView[1, i].Value, tblIMODataGridView[2, i].Value, null);
dataGridView1.Rows[i].Height = 100;
if (tblIMODataGridView[3, i].Value != null)
{
if (tblIMODataGridView[3, i].Value.ToString().Length != 0)
{
dataGridView1[2, i].Value = Image.FromFile(TORServices.PathData.Path_File_Reagent + "\\" + tblIMODataGridView[3, i].Value);
}
}
}
Cursor = Cursors.Default;
}
Date :
2013-11-30 13:39:16By :
TOR
Server 02
Load balance : Server 02
