Sean Lange (1/29/2013)
pwalter83 (1/29/2013)
Thanks Sean,
I have come to a point where I need to add the sql code within this:
---------------------------------------
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
End Sub
---------------------------------------
The SQL code would be as you suggested- "select Columns from MyTable where Col1 = Combobox 1 and Col2 = Combobox 2" but I dont know what vb.net syntax I need to enter this in.
Any suggestions would be welcome. Thanks,
Paul
I would make two suggestions. First give your button a name that means something. Button1 is like calling a column Column1 in sql, maybe something like btnSearch. Not naming your controls is a habit that is really tough to break unless you start early.
Secondly, don't run that sql code. Instead execute a stored procedure and pass the combobox values as parameters. Look up the syntax with google/bing/whatever. There are a number of ways to query data from the database with .NET.
Slowly but not steadily, I have reached here now:
---------------------------------------------------------------
using System;
using System.Data;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Globalization;
using System.Text.RegularExpressions;
using System.Security.Principal; // here is the security namespace you need
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
protected void Button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE");
connection.Open();
SqlCommand sqlCmd = new SqlCommand("SELECT Office_cd,Trade_cd, system_name, interface_direction, last_update_dt FROM header WHERE office_cd = @Value1 AND trade_cd =@Value2", connection);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlCmd.Parameters.AddWithValue("@Value1", Office_cd.SelectedItem.Text);
sqlCmd.Parameters.AddWithValue("@Value2", trade_cd.SelectedItem.Text);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
TextBox1.Text = dt.Rows[0]["Office_cd"].ToString();
//Where ColumnName is the Field from the DB that you want to display
TextBox2.Text = dt.Rows[0]["Trade_cd"].ToString();
}
connection.Close();
}
------------------------------------------------------------
However, I am now getting this error on Datatable- Error 1 The type or namespace name 'DataTable' could not be found (are you missing a using directive or an assembly reference?) . Inspite of including 'using System.Data;' reference, I get this error, would you know how it can be corrected ?
Thanks