Hi, Select * from TABLE Where X Is Null Pandian S

Hi, I think this will help to u Cstring="Server=;DataBase=DOCTOR;UID=sa;PWD=" Pandian S

Hi, - Can I see the COFF Format physically ? - If It is 'YES', How Can I ? Thankx in advance

Hi, - Normally, 'Unmanaged COM' can be called in .NET through RCW(Runtime Callable Wrapper), So the COM which U have used is not supported by the .NET RCW. - May I now the COM Name, Is It Created By U / Not, In which application the COM Created. With Regards, Pandian S

Hi, I think the following code will fulfill your requirement. TextBox1_KeyPress ----------------- If Asc(e.KeyChar) = 13 Then MsgBox("The Data You Have Entered : " & TextBox1.Text, MsgBoxStyle.Information) End If With Regards, Pandian S

Hi, U can try the following 'CAST' ------------------------------ SELECT Clock_Nbr, CAST(Punch AS VARCHAR(20)), Seq_No FROM TIME_POST_WORK ORDER BY Punch With Regards, Pandian S

Hi Friend, If U want to get the 10th Row: ------------------------------ SELECT TOP 1 * FROM (SELECT top 10 * FROM TABLENAME ORDER BY NUMERICCOLUM) AS SUBS order by NUMERICCOLUM desc If U want to get the 12th Row: ------------------------------ SELECT TOP 1 * FROM (SELECT top 12 * FROM TABLENAME ORDER BY NUMERICCOLUM) AS SUBS order by NUMERICCOLUM desc With Regards, Pandian S

Hi Friend, Can you change the line as follows. .Parameters.Add("@percentage", 100) - I think 'Add' Method is enough here. With Regards, Pandian S

Hi Friend, I Envisage the has two Columns. Private Con As SqlConnection Private Com As SqlCommand Private DSET As DataSet Con = New SqlConnection("Your Connection String") Com = New SqlCommand("Insert Values(@ID,@Name )", Con) '/*** If the TWO column are String Type ***/ Com.Parameters.Add("@ID", SqlDbType.VarChar, 5) Com.Parameters.Add("@Name", SqlDbType.VarChar, 50) DSET = New DataSet() DSET.ReadXml("WW.xml") Dim R As Int32 Con.Open() For R = 0 To DSET.Tables(0).Rows.Count - 1 Com.Parameters("@ID").Value =DSET.Tables(0).Rows(R)(0) Com.Parameters("@Name").Value =DSET.Tables(0).Rows(R)(1) Com.ExecuteNonQuery() Next Con.Close() With Regards, Pandian S

Hi Friend. in WebForm1 ----------- Dim Send_Data set Send_Data = createobject("Microsoft.XMLDOM") Send_Data.load "WebForm2.aspx?popup='data'" In WEBForm2 ----------- Page_Load ---------- Dim Somewhere Somewhere = Trim(Request.QueryString("popup")) You can use the 'Somewhere' variable to display the result 'data'. With Regards, Pandian S

Hi Friend, You can change your Page in Debug Mode as follows 1. Select BUILD Menu. 2. And Select CONFIGURATION MANAGER. 3. Change to 'Debug' in 'Active Solution Configuration' Combo. 4. And also Change to 'Debug' in 'Configuration' column in the Grid. 5. Click Button 'Close' Now You can Debug Your page. Otherwise the Cursor will not be allowed to Break on your Breakpoint. With Regards, Pandian S