Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Web application design query


Web application design query

Author
Message
pwalter83
pwalter83
Say Hey Kid
Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)

Group: General Forum Members
Points: 682 Visits: 2131
Hello,

I am new to web application designing and using .net (MS Visual Studio 2010) to design an application.

The issue I have is to display information on a table based upon the 2 values selected by the user in the drop down lists. When the user presses the Find button, the results should be displayed in the form of a table from a table.

Could someone please tell what component (table or ???) I need to select from the list and what code would need to be written to associate the 'Find' button to the table.

Thanks inadvance for your help. Please find the screenshot for the application attached.

Thanks,
Paul
Attachments
Screenshot.bmp (14 views, 706.00 KB)
Sean Lange
Sean Lange
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16512 Visits: 16985
pwalter83 (1/28/2013)
Hello,

I am new to web application designing and using .net (MS Visual Studio 2010) to design an application.

The issue I have is to display information on a table based upon the 2 values selected by the user in the drop down lists. When the user presses the Find button, the results should be displayed in the form of a table from a table.

Could someone please tell what component (table or ???) I need to select from the list and what code would need to be written to associate the 'Find' button to the table.

Thanks inadvance for your help. Please find the screenshot for the application attached.

Thanks,
Paul


I don't quite understand your question here. You have two comboboxes. I assume you want to run a query that is something like "select Columns from MyTable where Col1 = Combobox 1 and Col2 - Combobox 2"?

I don't understand what you mean about associating the Find button to a table. The button will fire a click event. That click event will do something based on the values in your comboboxes.

If you can try to explain what your question/confusion is I can try to help.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
pwalter83
pwalter83
Say Hey Kid
Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)

Group: General Forum Members
Points: 682 Visits: 2131
Sean Lange (1/28/2013)
pwalter83 (1/28/2013)
Hello,

I am new to web application designing and using .net (MS Visual Studio 2010) to design an application.

The issue I have is to display information on a table based upon the 2 values selected by the user in the drop down lists. When the user presses the Find button, the results should be displayed in the form of a table from a table.

Could someone please tell what component (table or ???) I need to select from the list and what code would need to be written to associate the 'Find' button to the table.

Thanks inadvance for your help. Please find the screenshot for the application attached.

Thanks,
Paul


I don't quite understand your question here. You have two comboboxes. I assume you want to run a query that is something like "select Columns from MyTable where Col1 = Combobox 1 and Col2 - Combobox 2"?

I don't understand what you mean about associating the Find button to a table. The button will fire a click event. That click event will do something based on the values in your comboboxes.

If you can try to explain what your question/confusion is I can try to help.


Thanks for your reply. The query you mentioned is exactly I wish to write but it should be executed when the 'Find' button is clicked.

The results from the query then should be displayed in a table format having several columns depending upon the 2 values selected by the user.
Sean Lange
Sean Lange
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16512 Visits: 16985
OK easy enough. As I said previously you will need to use an event of the button. Since you want this to happen when the user clicks the button, you will use the click event.

Just add code to your click event to run your query. Stick the results of your query into a datatable and bind your gridview to the datatable.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
pwalter83
pwalter83
Say Hey Kid
Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)

Group: General Forum Members
Points: 682 Visits: 2131
Sean Lange (1/28/2013)
OK easy enough. As I said previously you will need to use an event of the button. Since you want this to happen when the user clicks the button, you will use the click event.

Just add code to your click event to run your query. Stick the results of your query into a datatable and bind your gridview to the datatable.


Thanks Sean,

Do I need to add the code to the 'OnClientClick' property ? This is the only property I can see on the list.

Also, I cannot find the component 'datatable', is it the same as 'Table' ?

lastly, do you refer to gridview as the component or as a property ?

Sorry for the botheration.

Thanks.
Sean Lange
Sean Lange
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16512 Visits: 16985
pwalter83 (1/28/2013)
Sean Lange (1/28/2013)
OK easy enough. As I said previously you will need to use an event of the button. Since you want this to happen when the user clicks the button, you will use the click event.

Just add code to your click event to run your query. Stick the results of your query into a datatable and bind your gridview to the datatable.


Thanks Sean,

Do I need to add the code to the 'OnClientClick' property ? This is the only property I can see on the list.

Also, I cannot find the component 'datatable', is it the same as 'Table' ?

lastly, do you refer to gridview as the component or as a property ?

Sorry for the botheration.

Thanks.


I am going to guess you don't know much about web development. The OnClientClick event is the client side event for clicking. You want the server side event (unless you are going to do this via jquery).

DataTable belongs to the System.Data namespace. I don't know how you are querying your data. If you are using a SqlDataSource you will have to add parameters to the select property and requery server side.

The GridView is what you will use to display the results of your query.

I would highly recommend you dig around and find some tutorials on basic asp.net development. Not trying to sound rude but you really need to understand what you are doing and from your posts it seems you are very unfamiliar with how this stuff works. Web development is quite different than windows applications because you have code that runs on the server and code that runs on the client and you have to deal with both.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
pwalter83
pwalter83
Say Hey Kid
Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)

Group: General Forum Members
Points: 682 Visits: 2131
Sean Lange (1/28/2013)
pwalter83 (1/28/2013)
Sean Lange (1/28/2013)
OK easy enough. As I said previously you will need to use an event of the button. Since you want this to happen when the user clicks the button, you will use the click event.

Just add code to your click event to run your query. Stick the results of your query into a datatable and bind your gridview to the datatable.


Thanks Sean,

Do I need to add the code to the 'OnClientClick' property ? This is the only property I can see on the list.

Also, I cannot find the component 'datatable', is it the same as 'Table' ?

lastly, do you refer to gridview as the component or as a property ?

Sorry for the botheration.

Thanks.


I am going to guess you don't know much about web development. The OnClientClick event is the client side event for clicking. You want the server side event (unless you are going to do this via jquery).

DataTable belongs to the System.Data namespace. I don't know how you are querying your data. If you are using a SqlDataSource you will have to add parameters to the select property and requery server side.

The GridView is what you will use to display the results of your query.

I would highly recommend you dig around and find some tutorials on basic asp.net development. Not trying to sound rude but you really need to understand what you are doing and from your posts it seems you are very unfamiliar with how this stuff works. Web development is quite different than windows applications because you have code that runs on the server and code that runs on the client and you have to deal with both.



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
Sean Lange
Sean Lange
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16512 Visits: 16985
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.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
pwalter83
pwalter83
Say Hey Kid
Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)

Group: General Forum Members
Points: 682 Visits: 2131
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
pwalter83
pwalter83
Say Hey Kid
Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)Say Hey Kid (682 reputation)

Group: General Forum Members
Points: 682 Visits: 2131
pwalter83 (1/30/2013)
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





Thanks Sean, resolved this by changing to .NET Framework 4.0.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search