Fetch The Value to textbox from one form to another form

Sathya Narayan

12y1.9kVisual Basic .NET

hi ,

I need to fetch the values to textbox from one form to another .

This is my code

Private Sub display()

connection = New SqlConnection(con)

Dim Sql As String = "SELECT ID,Name from tblTickets where stu='A' order by Name"

da1 = New SqlDataAdapter(Sql, connection)

'conn.Open()

ds1 = New DataSet()

Dim commandBuilder1 As SqlCommandBuilder = New SqlCommandBuilder(da1)

da1.Fill(ds1, "Pub")

dsource1.DataSource = ds1.Tables("Pub")

connection.Close()

DataGridView3.DataSource = dsource1

DataGridView3.Refresh()

DataGridView3.Columns(0).Width = 100

DataGridView3.Columns(1).Width = 200

End Sub

Private Sub DataGridView3_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView3.CellContentClick

i = DataGridView3.CurrentRow.Index

Dim dgv As DataGridView = CType(sender, DataGridView)

Dim thisCell As DataGridViewCell = dgv.SelectedCells(0)

Dim selCell As Integer = thisCell.ColumnIndex

Dim sch As New Schedules

sch.txtID.Text = DataGridView3.Item(0, i).Value.ToString()

'Form1.txtflight.Text = DataGridView3.Item(1, i).Value.ToString

Me.Dispose()

End Sub

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sathya Narayan12y ago
Fetching the value from ListView to Combobox and Textbox
Hi,

I am Loading the values from listview to textbox and combobox,it has just loading for textbox and which has not been loading to combobox.This is what the code, i am using to implement.

Filling To List View
Public Sub FillList()
sSql = "SELECT pname as ' Product',rate as 'Rate',ProductGroup as 'Product Group',Vatt as 'Vat',Unit as 'Unit',slno from Product_View where stu='A'"

With ListView1
.Clear()
.View = View.Details
.FullRowSelect = True
.GridLines = True

.Columns.Add("Product Name", 150)
.Columns.Add("Rate", 50)
.Columns.Add("Product Group", 150)
.Columns.Add("Vat", 50)
.Columns.Add("Unit", 50)
.Columns.Add("SLNO", 60)
FillListView(ListView1, GetData(sSql))
End With
End Sub

Fetching The Values To ListView to Textbox and Combobox

Private Sub ListView1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListView1.SelectedIndexChanged
If ListView1.SelectedItems.Count > 0 Then

Product.txtproductname.Text = ListView1.SelectedItems(0).SubItems(0).Text
Product.txtrate.Text = ListView1.SelectedItems(0).SubItems(1).Text
Product.cboproductgroup.Text = ListView1.SelectedItems(0).SubItems(2).Text
Product.cbovat.Text = ListView1.SelectedItems(0).SubItems(3).Text
Product.cbounits.Text = ListView1.SelectedItems(0).SubItems(4).Text
Product.Label12.Text = ListView1.SelectedItems(0).SubItems(5).Text
Product.cmd_save.Text = "Update"
Product.DataGridView1.Visible = False
Product.GroupBox3.Visible = False
Product.Height = 245
End If
End Sub

With Regards,
Sathya
0
Vulpes12y ago
The first error is caused by the compiler not being sure that 'fm' and 'sm' have been assigned values by the time 'avg' needs to be calculated.

To get rid of it, just initialize these variables to zero say:

double fm = 0.0;
double sm = 0.0;

The reason for the second set of errors is that you haven't parsed the text values to the double parameters the method is expecting. Also the method is not returning a value.

So change the method signature to:

public double TotalMarks(double m1, double m2, double m3)

and add this line at the foot of the method:

return avg;

Now change the code in the TextChanged event handlers to the following:

double m1, m2, m3;
double.TryParse(txtfi.Text, out m1);
double.TryParse(txtsi.Text, out m2);
double.TryParse(txtti.Text, out m3);

txtam.Text = TotalMarks(m1, m2, m3).ToString();

Note that if, for some reason, what's in a textbox can't be parsed to a double, then zero will be used instead.

0
Sathya Narayan12y ago
hi,

I am trying to calculate the internal marks of an student.Taking 4 textboxes in that 3 textboxes for internals marks and 4th textbox for calculating the average marks of the student
i am getting an error message while calculating the values using this formula.

This is my code

public void TotalMarks(double m1, double m2, double m3)
{
double fm;
double sm;
double avg;
if((m1>=m2 )&(m1>=m3))
{
fm = m1;
if (m2 >= m3)
{
sm = m2;
}
else
{
sm = m3;

}
}
if ((m2 >= m3) & (m2 >= m1))
{
fm = m2;
if (m1 >= m3)
{
sm = m3;
}
else
{
sm = m3;

}
}
if ((m3 >= m2) & (m3 >= m1))
{
fm = m1;
if (m1 >= m2)
{
sm = m1;
}
else
{
sm = m2;

}
}

avg = (fm+sm) / 2; // error unassinged local variable fm and sm
}

private void txtfi_TextChanged(object sender, EventArgs e)
{
txtam.Text = TotalMarks((txtfi.Text), (txtsi.Text), (txtti.Text)); //error cannot convert string to double
}

private void txtsi_TextChanged(object sender, EventArgs e)
{
txtam.Text = TotalMarks((txtfi.Text), (txtsi.Text), (txtti.Text)); //error cannot convert string to double
}

private void txtti_TextChanged(object sender, EventArgs e)
{
txtam.Text = TotalMarks((txtfi.Text), (txtsi.Text), (txtti.Text)); //error cannot convert string to double
}

}
can you please help?
0
Vulpes12y ago
Yes, that would explain it since a Windows Service can't interact with the user's desktop.
0
Sathya Narayan12y ago
Hi,

Thanks for your reply.It has got changed in project-->properties instead of Windows Form Application,i took the value Windows Service.For that issue it wasn't take the showdailog function.Now it is working fine.

regards

satya
0
Vulpes12y ago
If you've already created an instance of the Schedules form and it's still open, then I don't understand why that code doesn't work - it works fine in some example code I've just tried.

Anyway, there are other ways to get a reference to an existing instance of a form.

Try replacing this line:

Schedules.txtID.Text = DataGridView3.Item(0, i).Value.ToString()

with these:

Dim sch As Schedules = CType(Application.OpenForms("Schedules"), Schedules)
Dim tb As TextBox = CType(sch.Controls("txtID"), TextBox)
tb.Text = DataGridView3.Item(0, i).Value.ToString()

This code assumes that txtId is placed directly on the Schedules form and not in some container such as a Panel or GroupBox.

0
Sathya Narayan12y ago
But without creating the instance its giving error in the code.The txtID value not shown in the event.
0
Vulpes12y ago
If Schedules is a Form and txtID is a textbox on that form, then I'd expect the following code to work in VB.NET:

i = DataGridView3.CurrentRow.Index
Dim dgv As DataGridView = CType(sender, DataGridView)
Dim thisCell As DataGridViewCell = dgv.SelectedCells(0)
Dim selCell As Integer = thisCell.ColumnIndex
Schedules.txtID.Text = DataGridView3.Item(0, i).Value.ToString()
Me.Dispose()

The important thing here is not to create a new instance of Schedules.

The above code should access the existing instance, albeit using hidden code generated by the VB.NET compiler.
0