I have write a program to insert data in sql server using ASP.net Service,I have tried below code bit its not working .Please check below code and advise how to do that...
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
			
			
			
				B4X:
			
		
		
		using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BLToolkit.Data;
using KHEXPORTSLIBRARY;
using System.Data;
namespace SMSDemo
{
    public partial class FrmToDo : System.Web.UI.Page
    {
        DbManager Db = new DbManager();
        public static string StrQuery;
        
        protected void Page_Load(object sender, EventArgs e)
        {
            StrQuery = "";
            StrQuery = Request.QueryString["Param"];
            Db.SetCommand(StrQuery).ExecuteScalar();
        }
    }
}
	
			
				B4X:
			
		
		
		Dim job As HttpJob
job.Initialize("Job1", Me)
StrQuery = "Insert Into KhArind.Dbo.Todo Values('" & StrDate  & "','" & CboAssignTo.SelectedItem  & "','" & TxtMessage.Text.Replace(CRLF," ") & "',0,'" & StrDueDate & "')"
        job.PostString(StrURLPath&"SMSDemo/FrmToDo.aspx",StrQuery)