|
Good day Y'all. I'm having a problem using a GridView with Edit Functionality. As can be seen below, I'm
using an SqlDataSource control to connect to a MySQL Odbc provider.
<asp:GridView ID="GridView1"
AutoGenerateColumns="false"
AutoGenerateEditButton="true"
DataSourceID="Hotel"
DataKeyNames="reservation_id" runat="server">
<Columns>
<asp:BoundField DataField="reservation_id" ReadOnly="True" HeaderText="ID" />
<asp:BoundField DataField="room_type" HeaderText="Client ID" />
<asp:BoundField DataField="room_number" HeaderText="Room Type" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="Hotel" runat="server"
ConnectionString="Dsn=Hotel"
ProviderName="System.Data.Odbc"
SelectCommand="SELECT reservation_id, room_type, room_number FROM reservations WHERE room_number IS NULL;"
UpdateCommand="UPDATE reservations SET room_type=@room_type, room_number=@room_number WHERE reservation_id=@reservation_id;">
</asp:SqlDataSource>
Problem is that when I view the web page and edit a row, after clicking on the Update Linkbutton, the
GridView as well as the MySQL monitor shows no updates. I'll appreciate any help.
Live in fragments no longer. Only connect.
-- modified at 8:17 Thursday 20th July, 2006
|
|
|
|
|
I'm not big on the grid view, but would you not need to tell the update command which field s relate to which parameters?
|
|
|
|
|
I actually tried declaring the parameters, even though I didn't include the code, but it still didn't work.
Live in fragments no longer. Only connect.
|
|
|
|
|
Because you are using the SqlDataSource control to connect to the ODBC database, so you might need to check a couple of things regarding to the parameters:
+ Use the correct place holder.
+ Use the correct order of the parameters.
|
|
|
|
|
please what do you mean by placeholders and could you give me examples.
Thanx
Live in fragments no longer. Only connect.
|
|
|
|
|
By this I mean the ODBC does not support named parameters, but the positional parameters, so you will use the placeholder ? instead. Also, when you define the update parameters, they should appear in the correct order as: room_type, room_number, and reservation_id. The sample code looks something like:
<asp:SqlDataSource ID="Hotel" runat="server"
ConnectionString="Dsn=Hotel"
ProviderName="System.Data.Odbc"
SelectCommand="SELECT reservation_id, room_type, room_number FROM reservations WHERE room_number IS NULL;"
UpdateCommand="UPDATE reservations SET room_type=?, room_number=? WHERE reservation_id=? ;">
<UpdateParameters>
<asp:Parameter Name="room_type"/>
<asp:Parameter Name="room_number"/>
<asp:Parameter Name="reservation_id"/>
</UpdateParemeters>
</asp:SqlDataSource> For more information, see:
Using Parameters with the SqlDataSource Control [^]
|
|
|
|
|
Hi ,
please i want to know how to add some controls into ma application but with code not with design
i want to write this
Me.textbox1.location = system.drawing.point(74,65)
i don't know somehting like that but the problem is that this doesn't work i think because it is not in his place , actually i don't know
i want you tell me how to do this because i need it
i will explain to you to let you know the case
i product a wire & each wire use two reels , each real has its section & .... but the problem is that i don't know how many reels in each wire so i need to ask for the number of reels used in that wire & depond on this number i will add controls , for each number i will add a textbox , label , dropdownlist ....
can you tell me how to do that ?
thank you
try to be good if you can't be the best
|
|
|
|
|
This KB[^] can get you started working on dynamic controls. Because you don't know the number of dynamic controls to build, so you need to persist it in the ViewState for example so that you can base on this to rebuild the dynamic control on postback.
|
|
|
|
|
Hi,
Is is possible to deploy a web application simultaneously on more than 1 IIS server using vs.net setup project(auto deployment wizard)?
Please update if any one knows it.
HV
|
|
|
|
|
The VS setup project is not that strong to allow you to deploy a web application to multiple servers. I think that you need to handle it on your own.
|
|
|
|
|
Hi minhpc_bk,
Thank you.
Do you have idea on any another deployment tool which supports the deployment to multiple server?
Will "Wise for Visual Studio" work?
Also as you mentioned with VS.Net setup we have to handle it by our own. Can you give me some idea on how to go about it.It will be helpful.
Thank you,
HV
|
|
|
|
|
hiraljv wrote: Do you have idea on any another deployment tool which supports the deployment to multiple server?
Will "Wise for Visual Studio" work?
I don't know, you may need to check out the documetation of Wise as well as Install Shield to see if they support what you need.
hiraljv wrote: Also as you mentioned with VS.Net setup we have to handle it by our own. Can you give me some idea on how to go about it.It will be helpful.
Basically, when the web setup project runs, it will create a virtual directory at the default web server on the current machine, do some configurations, and copy the content files. So I think you can manage to use the Windows Management Instrumentation (WMI) to connect to the selected servers, and make a web site, and copy the web pages to the destination location. If you're not familiar with WMI, you can search for "create web site with C#" or something like that on google, and you can start with from there.
|
|
|
|
|
|
Where i can download IIS 5.0 ..I have Window XP operating system.
Life is not easy ,let's make it.
|
|
|
|
|
It's part of the OS, and you can choose to install from the Add/Remove Windows Components. But if you use the XP Home Edition, you may only need the built-in server in VS 2005.
|
|
|
|
|
Hi all,
have you any idea about maximum length of URL in IE?
|
|
|
|
|
Maximum URL length is 2,083 characters in Internet Explorer
|
|
|
|
|
|
|
Hi i m working on network system but i have installed .net framwork on my pc.tell me how can i access localhost server which is installed on my pc. I want to make my asp.net project only on my pc while using localhost ..IIS5.0..
What should I do to make project on asp.net with my IIS .while my pc connected to network ..Is there any setting which is seperae to access IIS or Othere server.?
plzz help me i m eger to work on .net.
Life is not easy ,let's make it.
|
|
|
|
|
Just put your web application under the local wwwroot folder. Access it using http://localhost/
And in this case, life is that easy.
If you are running visual studio and you create a new project, then this is how it will work.
|
|
|
|
|
IIS5.0? Why not IIS6.0?
"The key, the whole key, and nothing but the key, so help me Codd"
|
|
|
|
|
Hi
I want to give Microsoft Certified Application Developer (MCAD) exam but i don't have study material please can any one send me links and name of books which i should read . Please reply me
|
|
|
|
|
A GuidLine:
3dbc337b-1df8-41b4-ac28-729b1320bd38
|
|
|
|
|
Thanks for reply
What is that ? Sorry didn't get that
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
