ASP.NET

Not Active9-Aug-06 9:05

9-Aug-06 9:05

Try using server controls, ie change the INPUT to <asp:textbox>. Also, since you are using 2.0 why not make use of the AccessDataSource control? You can configure this use the control as input to your select statement

only two letters away from being an asset

Soot9-Aug-06 9:37

9-Aug-06 9:37

Isn't the AccessDataSource control only used for a static source file and not a SQL service?

Not Active9-Aug-06 10:13

9-Aug-06 10:13

conLath = New OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\tower1\home01\nlms1\datab2000\latham.mdb")

You are using an Access dataabase not SQL Server correct?

only two letters away from being an asset

Soot9-Aug-06 10:27

Re: ASP.NET DataGrid Parameter [modified]

9-Aug-06 10:27

No that was an example. I however am using a SQL 2000 Database and need to reproduce the same thing that example code was doing.

Soot9-Aug-06 10:30

9-Aug-06 10:30

Let me clarify...

<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 [DOCPROJ] WHERE [IDENT]='1'">
</asp:SqlDataSource></code>

I need to put a parameter from an input box where the 1 is in [IDENT]='1', I know the syntax for the parameter but I don't know how to pass a user-entered parameter to there.

I need something that does this...but works:

Please Enter an ID<br>
<input name="selection" type="text" id="selection.value">
<input type="submit" name="Submit" value="Submit">

...

SelectCommand="SELECT [OVERVIEW] FROM [DOCPROJ] WHERE [IDENT]='%" + selection.value + "%'">

Not Active9-Aug-06 13:02

9-Aug-06 13:02

The answer is the same as I've stated previously. Use Server Controls instead of HTML controls and configure your datasource to use the value from the textbox in the select statement.

Also, in the future state your problem clearly in the first place. You will get an answer quicker and no waste everyones time Mad | :mad:

only two letters away from being an asset

Soot10-Aug-06 2:33

10-Aug-06 2:33

Your answers are ambigious, I don't know what you mean by Server Controls how to configure my datasource (which is SQL not Access) to use the textbox...it was my problem in the first place.

Not Active10-Aug-06 5:13

Re: ASP.NET DataGrid Parameter [modified]

10-Aug-06 5:13

The answers are not ambiguous.

Show some respect to this forum and the people in it who try to help, do some research on your own first before asking questions you don't even understand how to ask. If you don't understand the difference between server controls and html controls then pick up a book, use msdn, whatever, don't expect people to do everything for you. Mad | :mad:

only two letters away from being an asset

Soot10-Aug-06 5:28

10-Aug-06 5:28

Don't answer my questions or the post if you haven't:

A. Read the post to begin with to understand from the beginning I'm using SQL and not Access, and to understand that some code were posted as examples. Basically Learn2Read.

B. Have an answer to the post, not just "go look at MSDN"

Your posts were just forum trolling and nothing more. I've checked MSDN, I've posted here a month before with no success, and I've read countless sites and articles from (datagridgirl.com to .edu sites on ASP).

I am looking for someone familiar with Datagrids, not someone to tell me to look somewhere else, thanks. OMG | :OMG:

I'm sure I'll have to repost this question a month later thanks to you filling it up with dribble-drabble and off topic posts. And I'm sure you'll keep filling it up after this post, neither answering anything remotely on topic or relating to datagrids and parameters to begin with; but rather defending your "helping" to get more posts for some reason. So please save me the trouble and don't respond anymore to this thread Mark Nvnairnaind because you are not helping.

-- modified at 11:34 Thursday 10th August, 2006

Not Active10-Aug-06 5:54

10-Aug-06 5:54

Soot wrote:
I am looking for someone familiar with Datagrids

http://www.codeproject.com/aspnet/datagriddemo.asp[^]

Soot wrote:
I've checked MSDN, I've posted here a month before with no success, and I've read countless sites and articles from (datagridgirl.com to .edu sites on ASP).

You need more help then posting here then.

Soot wrote:
I'm sure I'll have to repost this question a month later

Perhaps if you took that month to take a class and really learn you won't have to ask the same question again.

only two letters away from being an asset

Soot10-Aug-06 6:18

10-Aug-06 6:18

Again thanks for the useless reply Mark Nischalke. If you had taken any time to read the questions I posted etc. You would have known I was looking for just one simple answer to one question: How do you link a parameter from a text box to a parameter in the datagrids SELECT statement.

Obviously as for "needing more help" you should pick up a book sometime and maybe take some pills to address your A.D.D. problem.

And thanks for the life lessons Mark Nischalke I'm sure you go out and take a class on programming problems anytime you have a problem, probably due to the fact people like you provide no valuable input at all on these forums.

Not Active10-Aug-06 7:26