Click here to Skip to main content
15,906,708 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
AnswerRe: System Administration for Windows Pin
Jun Du23-Aug-06 4:46
Jun Du23-Aug-06 4:46 
GeneralRe: System Administration for Windows Pin
Mostafa Siraj23-Aug-06 8:13
Mostafa Siraj23-Aug-06 8:13 
Questionhow to make a dbx file Pin
Parshant Verma22-Aug-06 0:18
Parshant Verma22-Aug-06 0:18 
QuestionPassing Data from ASP.NET to Axis Web Service Pin
bryan paling21-Aug-06 19:24
bryan paling21-Aug-06 19:24 
AnswerRe: Passing Data from ASP.NET to Axis Web Service Pin
stevepham4225-Aug-06 0:22
stevepham4225-Aug-06 0:22 
QuestionRunning other Applications (exe) Pin
Md.Imdad21-Aug-06 10:41
Md.Imdad21-Aug-06 10:41 
AnswerRe: Running other Applications (exe) Pin
Jun Du22-Aug-06 12:44
Jun Du22-Aug-06 12:44 
QuestionASP .NET Datagrid SQL SELECT Parameter Problem Pin
Soot21-Aug-06 9:57
Soot21-Aug-06 9:57 
Ok first, I'll outline my project. It is a web application made to search and display records of archived technical documents. What I have right now is a page that uses datagrids (via drag and drop from Visual Studio 2005) to display columns of data from my SQL Test server.

What I need now is a way to create a simple form text box and create and pass a variable to the SELECT statement within the datagrids. All my attempts at this thus far, using both ASP and C# and MSDN knowledgebase, have ended in frustration.

Here is the code of the datagrid:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="OVERVIEW" HeaderText=" " SortExpression="OVERVIEW" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="
<%ConnectionStrings:trdConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:trdConnectionString2.ProviderName %>"
SelectCommand="SELECT [OVERVIEW] FROM [SUDS_TRD] WHERE [IDENT]='1'">
</asp:SqlDataSource>

What I need to do is where it says [IDENT]='1', is have that "1" be a parameter passed from an HTML form, perhaps looking like this WHERE [IDENT]='"% strIDENT %"', yet I do not know how to pass a parameter from an HTML form into that SELECT statement. Any help would be great as this is a problem holding up my project.

To reiterate, I need to:
A. create an html form text box
B. pass that textbox as a variable
C. place that variable into the SELECT statement for the ASP datagrid.

Any help would be great, example code, whatever it takes; the simpler the better =) Please just don't send me to MSDN's Datagrid Knowledge Base page as 1/2 the stuff there doesn't even work =[.

Thanks for any help in advance!
QuestionLarge Heap Doesn't Compact? Pin
BarV21-Aug-06 8:28
BarV21-Aug-06 8:28 
AnswerRe: Large Heap Doesn't Compact? Pin
Dave Kreskowiak21-Aug-06 8:44
mveDave Kreskowiak21-Aug-06 8:44 
GeneralRe: Large Heap Doesn't Compact? Pin
BarV21-Aug-06 8:58
BarV21-Aug-06 8:58 
AnswerRe: Large Heap Doesn't Compact? Pin
Guffa21-Aug-06 8:47
Guffa21-Aug-06 8:47 
GeneralRe: Large Heap Doesn't Compact? Pin
BarV21-Aug-06 8:59
BarV21-Aug-06 8:59 
GeneralRe: Large Heap Doesn't Compact? [modified] Pin
Dave Kreskowiak21-Aug-06 9:19
mveDave Kreskowiak21-Aug-06 9:19 
GeneralRe: Large Heap Doesn't Compact? Pin
BarV21-Aug-06 9:33
BarV21-Aug-06 9:33 
GeneralRe: Large Heap Doesn't Compact? Pin
Dan Neely21-Aug-06 9:38
Dan Neely21-Aug-06 9:38 
GeneralRe: Large Heap Doesn't Compact? Pin
Dave Kreskowiak21-Aug-06 9:57
mveDave Kreskowiak21-Aug-06 9:57 
GeneralRe: Large Heap Doesn't Compact? Pin
Dan Neely21-Aug-06 10:05
Dan Neely21-Aug-06 10:05 
GeneralRe: Large Heap Doesn't Compact? Pin
Dave Kreskowiak21-Aug-06 10:28
mveDave Kreskowiak21-Aug-06 10:28 
Question.net odbc provider Pin
Rothco21-Aug-06 6:41
Rothco21-Aug-06 6:41 
AnswerRe: .net odbc provider Pin
Dave Kreskowiak21-Aug-06 8:00
mveDave Kreskowiak21-Aug-06 8:00 
GeneralRe: .net odbc provider Pin
Rothco21-Aug-06 8:06
Rothco21-Aug-06 8:06 
QuestionProcess Killer Pin
DanB198321-Aug-06 6:19
DanB198321-Aug-06 6:19 
AnswerRe: Process Killer Pin
Dave Kreskowiak21-Aug-06 7:49
mveDave Kreskowiak21-Aug-06 7:49 
GeneralRe: Process Killer Pin
DanB198321-Aug-06 23:01
DanB198321-Aug-06 23:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.