440900914440900
1
440900914440900
2
:
1-Microsoft SQL Server
2-Visual Basic.NET
SQLVisual Basic.NET
SQL Server
Microsoft SQL ServerSQL Server
SQL
440900914440900
3
440900914440900
4
SQL ahmedpct1
st_testing
st_testingSt_id
int
St_name nchar(10)
St_name nchar(10)
St_mark int
St_imag image
440900914440900
5
Windows.NET Visual Basic
Visual Studio.NETWindows Visual Basic test
Data Sources
Database:
440900914440900
6
e Databas :
New Connection
Microsoft SQL ServerVisual Basic.NET
ahmedpct1DataSet.xsdVisual Basic.NET
440900914440900
7
SELECT COUNT(*) AS Expr1
FROM Table_st
SELECT COUNT(st_mark) AS Expr1
FROM Table_st
INSERT INTO [dbo].[Table_st] ([st_id], [st_name], [st_mark], [st_image])
VALUES (@st_id, @st_name, @st_mark, @st_image)
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click OpenFileDialog1.ShowDialog() Dim a1 = IO.File.ReadAllBytes(OpenFileDialog1.FileName) Me.Table_stTableAdapter.Inserimage(TextBox4.Text, a1) Me.Table_stTableAdapter.Fill(Me.Ahmedpct1DataSet.Table_st) End Sub
440900914440900
8
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click OpenFileDialog1.ShowDialog() Dim a1 = IO.File.ReadAllBytes(OpenFileDialog1.FileName) Me.Table_stTableAdapter.Inserimage(TextBox4.Text, a1) Me.Table_stTableAdapter.Fill(Me.Ahmedpct1DataSet.Table_st) End Sub
Label1.Text = Me. Table_stTableAdapter.con12(Me.Ahmedpct1DataSet.Table_st)