I have created a small application for mobile device using vs2008.
i can retrieve the data . But i cant insert the data's into the database.
These are methods i used to insert. But no work
Any one can help to solve this issue.
Method - 1
	
	
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
Method - 2
	
	
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
Method - 3
	
	
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
	
		
			
		
		
	
				
			i can retrieve the data . But i cant insert the data's into the database.
These are methods i used to insert. But no work
Any one can help to solve this issue.
Method - 1
			
				VB.NET:
			
		
		
		        Dim conn As New SqlCeConnection("Data Source=\Program Files\SmartDeviceProject8\11.sdf")
        conn.Open()
        Dim sqlstring As String = "insert into tblTest(EmpName) values(@EmpName)"
        Dim cmnd As SqlCeCommand = New SqlCeCommand(sqlstring, conn)
        Dim myname As String = "abcdef"
        cmnd.Parameters.AddWithValue("@EmpName", myname)
        cmnd.ExecuteNonQuery()
        conn.Close()Method - 2
			
				VB.NET:
			
		
		
		        Dim conn As New SqlCeConnection("Data Source=\Program Files\SmartDeviceProject8\11.sdf")
        Dim sqlstring As String = "insert into tblTest(EmpName) values('abcdef')"
        Dim concom As SqlCeCommand = conn.CreateCommand()
        conn.Open()
        Dim cmnd As SqlCeCommand = New SqlCeCommand(sqlstring, conn)
        cmnd.ExecuteNonQuery()
        Dim myreader As SqlCeDataReader
        myreader = cmnd.ExecuteReader
        conn.Close()Method - 3
			
				VB.NET:
			
		
		
			Dim conn As New SqlCeConnection("Data Source=\Program Files\SmartDeviceProject8\11.sdf")
        conn.Open()
        Dim qry As String = "insert into tblTest(EmpName) values('abcdef')"
        Dim cmd As SqlCeCommand = conn.CreateCommand()
        cmd.CommandType = CommandType.Text       
        cmd.CommandText = qry
        cmd.ExecuteNonQuery()
	conn.Close()
			
				Last edited by a moderator: 
			
		
	
								
								
									
	
		
			
		
		
	
	
	
		
			
		
		
	
								
							
							 
	 
 
		 
 
		 
 
		 
 
		