Re: GridView & SQLdatasourceproblems - ASP.NET Discussion Boards

Okay I got it.

This is my web.config in a brand new asp.net app.

<?xml version="1.0"?>
<!-- 

-->
<configuration>
	<appSettings/>
	<connectionStrings/>
	<system.web>
		<webServices>
			<wsdlHelpGenerator href="blank.aspx"/>
		</webServices>
		<compilation debug="true"/>
   

    <authentication mode="Windows"/>
	</system.web>
</configuration>

I changed it to a .aspx because the .htm and .html have issues out of the box basically. Where as the web server knows how to render the .aspx.

The location bar will not change. It will still show the address to the service. The page that loads up in the services location is the blank.aspx.

I just changed it from htm or html to aspx and this has worked when you go directly to my web service file service.asmx

-----------
when using a .htm the web config needed additional handlers to know what to do with the .htm which is why i changed it to aspx because i dont see why it would matter as long as the user sees the correct content.

-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford

Thanks a bunch for this jgasm. This worked perfectly. I would have posted this earlier, but I'm not allowed to post to this site from work. I can read all day long, but can't post. Roll eyes | :rolleyes:

I am having problems getting this to work. I have it where it inserts the data from some text boxes above. So It Inserts and Deletes just fine.

When it comes to updating and search for in between dates I have problems.

Ok in the dialog for the update command it has the command for updating the fields. So when you click update in the grid view where are the commands that make it update? It will not update. When you change something and click UPDATE it just goes right back to what it was.

Also how do I search for between dates? I have two text boxes and set the
SQLdatasource1.SelectCommand = String.Format("SELECT * From [Clipboard] WHERE [Date] Between {0} AND {1}", txtBeginningDate.Text, txtEndDate.Text);

Now when you enter 05-05-2008 in the text boxes and hit my SEARCH button it says: Failed to convert nvarchar to int. Where is it converting to INT? I have it set to nvarchar???

BTW I am using MVS 2008 Pro, and I am not writing a lot of these commands. It is generated for me but I can't seem to get it to do those things.

well let's take this one at a time.
first:
the date format issue.

Are you sure you don't need to do some kind of
Convert.ToDateTime(txtBeginningDate.Text) in order for the STRING in that text box to convert to DateTime? beause right now it is trying to take a set of characters and do something with them.

*You can only search legit by date when the field in the database is a DateTime field.

On your update command in the gridview make sure you have the Where clause set correctly. As in Update [tablename] Set [column name] = value WHERE id = ?
Does that make sense?

Check the update parameters in the gridview code to make sure it's using all the necessary ones. And by that I mean the where clause should use a column that identifies that record only.

Here's some help, could be quite a few things...if you want to narrow it down a bit Big Grin | :-D

-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford

Ok I see what you are saying.. but won't Convert.ToDateTime insert time to? I just need the Date. Also I do not have any parameters set up in the update. When someone clicks the update in the column (Update) next to the row (this is all built into the gridview) how do I specify what it is updating?

Well I guess if I still convert the users input (after setting a validation like \d{2}\\d{2}\\d{4}) it will still convert and do the calculation right. Because if you don't specify a time it will input 12:00:00 AM for you.

Also here is what I have for the update:

UPDATE Clipboard SET County = @County, Type = @Type, Date = @Date WHERE (IncidentNumber = @IncidentNumber)

so in your datasource you need to specify under the "Update Parameters" section each one of those

<UpdateParameters>
<asp:Parameter Name="county" Type="String" />
<asp:Parameter Name="type" Type="Int32" />
<asp:Parameter Name="Date" Type="DateTime" />
</UpdateParameters>

make sure the parameter datatypes match the sql data types.

-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford

Well one way to do this is to in the asp:Gridview tag code you can add

DataKeyNames="[id column name here]"

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="lvl1_id"
DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" GridLines="None">

This will make whatever you put in that for a column the way gridview identify records. So if you're records have an ID column, it should be that. This is probably the method I would use.

AND make sure your datasource has an update parameter set:

<UpdateParameters>
<asp:Parameter Name="lvl1_name" Type="String" />
<asp:Parameter Name="lvl1_id" Type="Int32" />
</UpdateParameters>

This is part of the DataSOURCE code. See the update parameters....in the SQLDataSource, this is where you can set it up. what this is saying it take the text box for lvl1_name and the lvl1_id for that record and perform a sql update. So if it's not updating, I would say it's because your datasource code in the .aspx is missing those update parameters. I will include a datasource next.

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:blahblah %>"
DeleteCommand="UPDATE [bmj_level1] SET [enabled] = 0 WHERE [lvl1_id] = @lvl1_id" InsertCommand="INSERT INTO [bmj_level1] ([lvl1_name]) VALUES (@lvl1_name)"
SelectCommand="SELECT [lvl1_id], [lvl1_name] FROM [bmj_level1] WHERE [enabled] = 1 ORDER BY [lvl1_name]" UpdateCommand="UPDATE [bmj_level1] SET [lvl1_name] = @lvl1_name WHERE [lvl1_id] = @lvl1_id">
<DeleteParameters>
<asp:Parameter Name="lvl1_id" Type="Int32" />
</DeleteParameters>

<UpdateParameters>
<asp:Parameter Name="lvl1_name" Type="String" />
<asp:Parameter Name="lvl1_id" Type="Int32" />
</UpdateParameters>

<InsertParameters>
<asp:Parameter Name="lvl1_name" Type="String" />
</InsertParameters>
</asp:SqlDataSource>

-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford

Ok I am sort of following you.. Here is my SQLDataSource Code:

<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="">" 
DeleteCommand="DELETE FROM [Clipboard] WHERE [IncidentNumber] = @IncidentNumber" 
InsertCommand="INSERT INTO [Clipboard] ([County], [Type], [Date]) VALUES (@County, @Type, @Date)" 
SelectCommand="SELECT * FROM [Clipboard]" 
UpdateCommand="UPDATE Clipboard SET County = @County, Type = @Type, Date = @Date WHERE (IncidentNumber = @IncidentNumber)";
<deleteparameters>
<asp:parameter name="IncidentNumber" type="Int32" />
</deleteparameters>
<updateparameters>
<asp:parameter name="County" type="String" />
<asp:parameter name="Date" type="String" />
<asp:parameter name="IncidentNumber" type="Int32" />
<asp:parameter name="Type" type="String" />
</updateparameters>
<insertparameters>
<asp:controlparameter controlid="txtCountyAdd" name="County" propertyname="Text" type="String" />
<asp:controlparameter controlid="txtTypeAdd" name="Type" propertyname="Text" type="String" />
<asp:controlparameter controlid="txtDateAdd" name="Date" propertyname="Text" type="String" />
</insertparameters>
</asp:sqldatasource>

DELETE and UPDATE do not work.... uhmm

modified on Tuesday, May 20, 2008 11:47 PM

In your <asp:gridview> code in there add this:

DataKeyNames="IncidentNumber" like this:

<asp:GridView ID="GridView1" runat="server" DataKeyNames="IncidentNumber" DataSourceID="SqlDataSource1" GridLines="None">

now try it.

-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford

awesome! your a life saver!

Ok now my time search isnt working...

You enter lets say: 1/1/2008 and 5/5/2008 and click a button.. here is the command:

SqlDataSource1.SelectCommand = String.Format("SELECT * FROM [Clipboard] WHERE [Date] Between {0} AND {1}", Convert.ToDateTime(txtBeginningDate.Text), Convert.ToDateTime(txtEndDate.Text));

But I get an Incorrect Syntax at 12?

in the sql server. in the "Clipboard" table...what is the data type of the "date" column...

actually change of plans try this.

SELECT * FROM [Clipboard] WHERE [Date] < {0} AND [Date] > {1}
or
SELECT * FROM [Clipboard] WHERE [Date] > {0} AND [Date] < {1}

-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford

modified on Wednesday, May 21, 2008 12:30 AM

Hey! Yes I have the Date column set to: DateTime.
It actually wants the Date and the Time but I am fine with that.
It doesn't have an option for just the date.

Anyways what I did was that I forgot the: " ' ' " between the beginning and ending dates.

Like I did it like this: Where [Date] Between {0} AND {1}

and it should of been: Where [Date] Between '{0}' AND '{1}'

it works though. thanks!

i can't believe i didn't even notice that. i should have known better.
it was late Frown | :(

-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford

lol! Its always the easiest problem that is the solution isnt it lol

hi Jacob Dixon,"Ok in the dialog for the update command it has the command for updating the fields. So when you click update in the grid view where are the commands that make it update? It will not update. When you change something and click UPDATE it just goes right back to what it was." for this please check the isnotpsotback property is given in Pageload event or not .

jgasm had me do something and it works great now. It was a DataKeyName value in the GridView code. I didn't have one set when I should of had it set to my ID Column.

As for the date/time thing I have figured it out. Thanks!

I have a simple login form that uses a master page. Im having a weird problem where when the login button is clicked the code behind cannot see the txtUserName.Text

The text box html is
<asp:textbox id="txtUsername" runat="server">

The code behind is

Dim currentUser As New DAL.AppUser
currentUser = currentUser.AuthenticateUser(txtUsername.Text, txtPassword.Text)

If currentUser.AppUserId > 0 Then
....

When I set a breakpoint at currentUser =... I see txtPassword.Text value but txtUsername.Text shows "" even though it is filled.

I checked that its view state is enabled. Tried deleting it and re-adding. Very weird.

Has anyone ever had this problem?

Try capital ID and make sure the ID value is unique on the page

<asp:textbox ID="txtUsername" runat="server" />

Wait, nevermind, you're using VB, could be anything then. Roll eyes | :rolleyes:

led mike

Dim currentUser As New DAL.AppUser
currentUser = currentUser.AuthenticateUser(txtUsername.Text, txtPassword.Text)

If currentUser.AppUserId > 0 Then
=====================================
where is this in the code behind? is this on page load? or page init?
when the page is submit and then loads those text boxes will be blank when the code goes for them.

also when you step through the application and you go one step past the txtUsername, what is the value then? is it still "" for currentUser?

-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford

The code behind is on login.click button event

if i had to guess it's because the page is posting back to itself when "login" is clicked and then you're code to collect the information is processing after the post back.

otherwise...i have no idea Frown | :(

-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford

I tried setting AutoPostBack to true and setting a string var on the txtUesrName_TextCahnged event but it show TxtUsrName.Text as NULL also so I am pissed at this point. Its a copy of another site that works fine. It must be some corruption in the asp page.

I think it's asp:TextBox, does the other one work with this capitalisation ?

Do you have code that sets the username value anywhere, such as page_load ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )