Posts by Pgmer

Hi All,

I have webservice im having webmethod in that which returns Boolean value.
Its retruning the correct output value only when the connection is pointing to localhost.
Can any one please guide me?

Thanks

Hi All,

I have webservice which i having webmethod which returns boolean value.
Its retruning the correct output value only when the connection is pointing to localhost.
Can any one please guide me?

Thanks

use string.Contains method...

you want evertying ready? What is ur idea behind the project?
Do you have any forms and controls on which ur going to show the data?

Please check ur join condition and pass more info on Query

In which line ur getting the error?

For that you need to bind ur listview with datasource, and in textchanged event of search textbox sort the datasource using dataview and again bind it to listview.

Dude dont call useless to Experts here... Show ur efforts.
We cant sit and write code for you... behave properly.

Why cant u set the MAXLength propery of textbox to 10?

In get values of array you need to see if any extra white space which doesnt have any value.

What is the data type of strId and strId2 and why r u doing CInt(10) - 1 and
CInt(4) - 1 As 10 and 4 are integer only. you need not to convert explicitly.
you can directly give 0 to 9 and 0 to 3
in which line ur getting the error?

Why can you join the 2 tables and get the result set and bind to grid?

Declare connection string in module level and consume in all the forms.If at all it changes u need to change only in the module not in all the forms.

Have you added the picture box to panel or groupbox?

Can you paste the code what your getting into strsql before running cmd.ExecuteNonQuery()

Before executing the Query i.e. cmd.ExecuteNonQuery()
Get the commandstring i.e:strsql and paste it on ur SQL server and see whether the statement is formated properly or not.

When u click on delete button
bind the second grid also with same dataset as firstform

If dr.HasRows Then
                While dr.Read
                  
                    DGVStudRecord.Rows.Add(dr(0), dr(1), dr(2), dr(3), dr(4), dr(5))
                    form2.grid.rows.add(dr(0), dr(1), dr(2), dr(3), dr(4), dr(5))

                End While
            End If

Try using the for loop.

for i as integer=0 to DataGridView1.rows.count-1
     ' Add your code which adds records to list  
   Next

Are you using listbox?

Get the datagridview records into table or dataset and loopthough the recods and add to list view in loop

On my Windows 7 it works perfect... I selcted the big font for date time in design time.. in ru time also it retains that font good. :)

Can you post some of ur code?
Which database are u using? is Framework installed on the system where ur getting this error?

Addrange method expects the array to be passed. Get all ur items in Array wich u want to add to combo. And pass the array in AddRange method...

Dim days() As String = {"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"}
        ComboBox1.Items.AddRange(days)

You are making the bindingSource1.DataSource = Nothing but not assigning to grid as source so the items are repeating. Either make the datasorce nothing and bind again, or clear the rows of grid before binding.

Set the font you want in the prorties of control at design time.
I just checked in VS2005 it worked for me.

IF it has solved your problem then plz mark the thread as solved.

Try
            Dim cn As SqlConnection
            Dim strCnn As String = "Your data base connection string"
            cn = New SqlConnection(strCnn)
            cn.Open()
            Dim comm As New SqlCommand("Your sp or Command text to get the data from DB", cn)
            '' If ur using Sp then Commandtype= CommandType.StoredProcedure if  'is  Text then comm.CommandType=CommandType.Text
            comm.CommandType = CommandType.StoredProcedure
            Dim da As New SqlDataAdapter(comm)
            Dim ds As New DataSet
            da.Fill(ds)
            ListBox1.Items.Clear()
            If ds.Tables.Count > 0 And ds.Tables(0).Rows.Count > 0 Then
                ListBox1.DataSource = ds
            End If
            ''Close your connections and commands.
        Catch ex As Exception
            ''Handle error if any
        End Try

Windows application?

What is your code to bind the records to grid?

If you have got the sollution then plz mark the thread as solved.

Yes you can save the content of file into database. And you can read the content back and display on controls..
Which data base are you using?

open VS 2005 go to File->New->Project
Select Windows. from templates select windows form application. and start designing ur project.. :)

Explain what you want clearly...

Can someone please show me how to show my paypal balance in a textbox what we need to understand from this?

First fill Cat combo with data member and value member.
Get the data for secod combo in dataset. in selected index changed event, get the key value of selected item using view sort the items and fill the secon combo.

Dim pinnum As String = "1234"
        Dim pinentered As String = TextBox1.Text
        If pinentered = StrReverse(pinnum) Then
            MessageBox.Show("Please eneter the pin properly")
        ElseIf pinentered = pinnum Then
            MessageBox.Show("Correct pin")
        End If

You need to get the pin u want to compare with into varioable pinnum here i took for example.

Get all the lable names into list and compare with Database list.

What will be selected text ur getting when only one item in textbox?
Just take that value and try to run on database check to see if there are records for it.

Then plz mark the thread as solveld :)

Then try to set the datasource as nothing.
Make the datasoruce of Listbox=nothing

If txtAddBIO.Text = "" Then
            MsgBox("Please paste BIO. Thank You.", MsgBoxStyle.Critical + MsgBoxStyle.OkOnly, "ERROR")
        Else
            selectmysqlquery = "SELECT `BIO_Entry` FROM `bio_db`.`bio_table` WHERE `BIO_Entry` = '" & Replace(txtAddBIO.Text, "'", "''") & "'"

            Dim connection As New MySqlConnection(connstr)
            Dim da As New MySqlDataAdapter(selectmysqlquery, connection)
            Dim ds As New DataSet()

            If da.Fill(ds) Then
                MsgBox("That BIO Already exist. Thank You!", MsgBoxStyle.Critical + MsgBoxStyle.OkOnly, "ERROR")
            Else
                Try
                    Dim cnn As MySqlConnection
                    Dim strCnn As String = connstr ' "your data base conection"
                    cnn = New MySqlConnection(strCnn)
                    cnn.Open()
                    Dim input As String
                    input = txtAddBIO.Text

                    Dim output As String() = input.Split(New String() {vbCr & vbLf, vbLf}, StringSplitOptions.None)
                    Dim bioEntry As String                    
                     If output.Length > 0 Then
                        For i As Integer = 1 To output.Length - 1
                            bioEntry = output.GetValue(i)                            addmysqlquery = "INSERT INTO `bio_db`.`bio_table`(`BIO_Entry`,`date_added`)VALUES ('" & bioEntry & "','" & lblDateTime.Text & "')"
                            mysqlCommand(addmysqlquery)
                            mysqlCommand.ExecutenonQuery()                            PopulateDataGrid()
                        Next
                    End If
                    MsgBox("New BIO Entry Successfully save",   MsgBoxStyle.Information + MsgBoxStyle.OkOnly, "SUCCESSFULL")
                    txtAddBIO.Clear()
                Catch ex As Exception
                    MessageBox.Show(ex.ToString)
                End Try

            End If

In your code ur not asking the command to execute
ur just saying mysqlCommand(addmysqlquery)
and ur not passing the array value to Query. please verify ur code.

please paste ur code in code tag...

Pass more info on ur objective...

Try
            Dim cnn As SqlConnection
            Dim strCnn As String = "your data base conection"
            cnn = New SqlConnection(strCnn)
            cnn.Open()
            Dim input As String
            input = TextBox1.Text

            Dim output As String() = input.Split(New String() {vbCr & vbLf, vbLf}, StringSplitOptions.None)
            If output.Length > 0 Then
                For i As Integer = 0 To output.Length - 1
                    ''here get the value of paragraph and pass to Query
                    ''Construct the Query properly.
                    Dim comm As New SqlCommand("Insert into table(column1,column2) values(value1,value2)", cnn)
                    comm.CommandType = CommandType.Text
                    comm.ExecuteNonQuery()
                Next
            End If
        Catch ex As Exception
            MessageBox.Show(ex.ToString)
        End Try
    End Sub

This is just example not working module.

Ur not using the join in proper way. Do u have Any relation between the two tables?
Primary key and foreign key constraints?

Hi X2fair,
have you tried to understand the code given by hericles ?
No need to have one more richtextbox.
I am using the same code as given by hericles

Dim input As String
input = RichTextBox1.Text

Dim output As String() = input.Split(New String() {vbCr & vbLf, vbLf}, StringSplitOptions.None)

Loop through this array and save the values in DB. Show your code if u have doubt.

Take the values and compare not text.

Hi Reverend Jim,
I thought just to give him the diretion not sollution. so that he can put his efforts.

Do you use any data base for your project? If yes then why cant you do it at the backend?

Try calling datagrid.refersh method after loading.

Whats your code? do u have writen any code? do you know how to recognise the paragraphs?