缺少RECORD想要添加到表中 [英] Missing RECORD WANT to Add in Table

问题描述

您好。全部......

我获取记录表学生数据并保存到MARKENTRY表。



例如：STUDENTDATA

Hi. All...
I GET RECORD FORM STUDENTDATA and SAVE to MARKENTRY Table.

For Example: STUDENTDATA

RegNo	Name	Class	Section
A100      	AAA	I         	A         
A200      	BBB	I         	A         
A300      	CCC	I         	A         
			
			
			
MARK ENTRY ( HEre A200 Record is Missing but i want to ADD RECORD A200)i don''t want to change Other REcord			
RegNo	Name	Class	Section
A100      	AAA	I         	A         
			
A300      	CCC	I         	A         

这里我第一次使用代码没有记录意味着添加新的RECORED工作正常..



下一次我想检查MARKENTRY Talbe如果有一些记录缺失那个记录我只想添加..

Here I Used Code For FIRST TIME NO RECORED MEANS Add New RECORED that work fine..

Next Time i want to Check MARKENTRY Talbe IF there some Recored Missing That Record Only I WANT TO ADD..

Dim strSQL8 As String = "SELECT * FROM MarkENTRY WHERE Class='" & cboClass.Text & "' and ExamDet='" & cboExType.Text & "'"
    Dim DaAp8 As New SqlDataAdapter(strSQL8, con)
    Dim Dset8 As New DataSet
        DaAp8.Fill(Dset8)



    Dim strSQL7 As String = "SELECT SD.Regno,SD.Sname,ED.ExamDet FROM StudentData as SD " & _
        " INNER JOIN Exam_List as ED ON SD.class='" & cboClass.Text & "' and ED.class='" & cboClass.Text & "'" ' and ED.ExamDet='" & cboExType.Text & "'"
    Dim DaAp7 As New SqlDataAdapter(strSQL7, con)
    Dim Dset7 As New DataSet
    DaAp7.Fill(Dset7)

        For i As Integer = 0 To Dset7.Tables(0).Rows.Count - 1
            vRegno = (Dset7.Tables(0).Rows(i).Item("Regno"))
            vSname = (Dset7.Tables(0).Rows(i).Item("Sname"))
            VEx_Type = (Dset7.Tables(0).Rows(i).Item("ExamDet"))
            con.Open()
            cmd.ExecuteNonQuery()
            con.Close()
        Next i
        MsgBox("Recored  Successfully Added")

请告诉我..

Please tell me..

推荐答案

要添加数据，请使用 INSERT 语句。

To add data use INSERT statement.

INSERT INTO STUDENTDATA (RegNo, Name, Class, Section)
VALUES ('A200','BBB', 'I', 'A')

关于INSERT语句的更多信息：

http://msdn.microsoft.com/en-us/library/dd776381（v = SQL.105）的.aspx [< a href =http://msdn.microsoft.com/en-us/library/dd776381(v=sql.105).aspx\"target =_ blanktitle =New Window> ^ ]

http://www.w3schools.com/sql/sql_insert.asp [< a href =http://www.w3schools.com/sql/sql_insert.asptarget =_ blanktitle =New Window> ^ ]

http://www.blackwasp.co.uk/SQLSelectInsert.aspx [ ^ ]

More about INSERT statement:
http://msdn.microsoft.com/en-us/library/dd776381(v=sql.105).aspx[^]
http://www.w3schools.com/sql/sql_insert.asp[^]
http://www.blackwasp.co.uk/SQLSelectInsert.aspx[^]

这篇关于缺少RECORD想要添加到表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！