Comments by Vipin Sharma (Top 32 by date)

i am using a HSPA modem on the place of GSM modem is there any problem with it ?
and i also dont find connection settings in Start -> Programs -> Accessories -> Communications -> HyperTerminal. so i cant run HyperTerminal . how can i find this in my pc.

i am not using any sms api , i recive sms from a website on my mobile no .and i want to connect it with my pc . and want to split the data so i can get the Customer name and Mobile no in my database .

thanks a lot its really help me in my project , i have few more que. can i use a landline no for send and recive message ? and use software for calls ,send and resive sms ?

thanks for your help it is really nice .

i want to get data from the official websites of multiplax so i can get accurate timeing of movie show but dont know how to do it ?

thanks for help , i will do this now .......

so it mean i cant do this ? but i dnt want to install database as a another software .
can i install my app and database at the same time ? by install only one exe ?

i dont wana like this ,i want to use my logo , my form desigions
how to do that ?

thanks a lotsss... its works and i am so happy for that...
thanks for help me :)
all i need to just add refrance Imports System.Data.Sql
it really helpfull for me . thank you ....

Dim instance As SqlDataSourceEnumerator = SqlDataSourceEnumerator.Instance

vb give error for Dim instance As SqlDataSourceEnumerator . why ? what refrance i have to use ?
or import ?

thanks i will try this. but i have a que. is it work when i dont run sql-server ? mean i install bt dont run it when i run my app.
coz it is a app so it is necessary to connecct with db without run sql .

thanks , i will try it today ...

yes i attach a backup copy to sql .
how i modify my connection string ?
i use sql-server as database and i dont knw how to deploy it with project. so i do this way .
can u guide me ,how to do it properly ? thanks .

thanx a lot ,its really helpfull 2 me.
but it is in C# so i have to convert it in vb .
ut thanx its really great help

so how to do that, ? i am created it for windos on vb .how to do that ? can u help

are u still here , i want to ask something

thanx , its really helpfull ... thank you .

thanx for this , but i cant totally understand it, coz i want to use this select command on many form and many time
how ,i give my query in this ?
coz for different form or opration every time the table and query change.. thank u for ur help ,

hmm ok thank .........

achuly no . i am just searching till now the best option that how to do that ? would i have to make my own ddl or anything else . achully i am a biginear

thanx its usefull but i think i need some more help about it .

this is not helping me, i want to add two values of rows not to add two new rows .thanx for reply

please have a look , i use this code for add row's value bt it don't work properly

Private Sub calculateIngradient_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim a, b As String
For i = 0 To DataGridView1.RowCount - 1
a = DataGridView1.Rows(i).Cells(0).Value
For j = 0 To DataGridView1.RowCount - 1
b = DataGridView1.Rows(j).Cells(0).Value
If a = b Then
DataGridView1.Rows(i).Cells(1).Value = DataGridView1.Rows(i).Cells(1).Value + DataGridView1.Rows(j).Cells(1).Value
DataGridView1.Rows(i).Cells(2).Value = DataGridView1.Rows(i).Cells(2).Value & " / " & DataGridView1.Rows(j).Cells(2).Value
DataGridView1.Rows.Remove(DataGridView1.Rows(j))

End If
Next
Next
End Sub

i am trying this code for add the values of datagrid view
but it give some error can u solve that

Private Sub calculateIngradient_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim a, b As String
For i = 0 To DataGridView1.RowCount - 1
a = DataGridView1.Rows(i).Cells(0).Value
For j = 0 To DataGridView1.RowCount - 1
b = DataGridView1.Rows(j).Cells(0).Value
If a = b Then
DataGridView1.Rows(i).Cells(1).Value = DataGridView1.Rows(i).Cells(1).Value + DataGridView1.Rows(j).Cells(1).Value
DataGridView1.Rows(i).Cells(2).Value = DataGridView1.Rows(i).Cells(2).Value & " / " & DataGridView1.Rows(j).Cells(2).Value
DataGridView1.Rows.Remove(DataGridView1.Rows(j))

End If
Next
Next
End Sub

i have a form ,on that i have a list of dish . i want to calculate all ingridient bt i want to add same ingradient .
i have datagridview on anotherform which name calculateIngradient .

Private Sub CalculateIng_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CalculateIng.Click

Dim a, b As String
Dim i, k, l As Int64
Try
For i = 0 To FinalList.Items.Count - 1
a = FinalList.Items(i)

Dim cmd1 As New SqlCommand(" select fldRID from RecepieMaster where fldRecepieName = '" & a & "' ", sqlc)
rd = cmd1.ExecuteReader
While rd.Read
k = rd("fldRID")
MsgBox(k)
End While

Try
rd.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try

Dim ds As New DataSet
Dim cmd3 As New SqlCommand("SELECT dbo.IngradientMaster.fldIngradientName , dbo.RecepieIngradientDetail.fldPPQ , dbo.RecepieIngradientDetail.fldUnit FROM dbo.IngradientMaster INNER JOIN dbo.RecepieIngradientDetail ON dbo.IngradientMaster.fldInID = dbo.RecepieIngradientDetail.fldInID WHERE (dbo.RecepieIngradientDetail.fldRID = " & k & ")", sqlc)
rd = cmd3.ExecuteReader
While rd.Read
calculateIngradient.DataGridView1.Rows.Add()
calculateIngradient.DataGridView1.Rows(calculateIngradient.DataGridView1.Rows.Count - 1).Cells(0).Value = rd("fldIngradientName")
calculateIngradient.DataGridView1.Rows(calculateIngradient.DataGridView1.Rows.Count - 1).Cells(1).Value = rd("fldPPQ") * NOofMainPeople.Text
calculateIngradient.DataGridView1.Rows(calculateIngradient.DataGridView1.Rows.Count - 1).Cells(2).Value = rd("fldUnit")
End While
Try
rd.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
Next
Catch ex As Exception

End Try

Try
For i = 0 To FinalFastList.Items.Count - 1
b = FinalFastList.Items(i)

Dim cmd2 As New SqlCommand(" select fldRID from RecepieMaster where fldRecepieName = '" & b & "' ", sqlc)
rd = cmd2.ExecuteReader
While rd.Read
l = rd("fldRID")
End While
Try
rd.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try

Dim ds As New DataSet
Dim cmd3 As New SqlCommand("SELECT dbo.IngradientMaster.fldIngradientName , dbo.RecepieIngradientDetail.fldPPQ , dbo.RecepieIngradientDetail.fldUnit FROM dbo.IngradientMaster INNER JOIN dbo.RecepieIngradientDetail ON dbo.IngradientMaster.fldInID = dbo.RecepieIngradientDetail.fldInID WHERE (dbo.RecepieIngradientDetail.fldRID = " & l & ")", sqlc)
rd = cmd3.ExecuteReader
While rd.Read
calculateIngradient.DataGridView1.Rows.Add()
calculateIngradient.DataGridView1.Rows(calculateIngradient.DataGridView1.Rows.Count - 1).Cells(0).Value = rd("fldIngradientName")
calculateIngradient.DataGridView1.Rows(calculateIngradient.DataGridView1.Rows.Count - 1).Cells(1).Value = rd("fldPPQ") * NoOfFastingPeop.Text
calculateIngradient.DataGridView1.Rows(calculateIngradient.DataGridView1.Rows.Count - 1).Cells(2).Value = rd("fldUnit")
End While
Try
rd.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
Next
Catch ex As Exception

End Try

calculateIngradient.Show()
End Sub

but how to do that ? i want to do it on form load event , plz help