SQLdatasource + gridview + mysql

Hi,

 

I have a sqldatasource and a gridview. I work with a mysql 3.51 database.

My problem is :

When I try tu update a record through the update command of the gridview, it doesn't work.  Here is my code :

<

asp:SqlDataSource ID="SQL_Panier" runat=server ConnectionString="<%$ ConnectionStrings:Connection to NI %>" ProviderName="<%$ ConnectionStrings:Connection to NI.ProviderName %>" SelectCommand="selectcommand"

UpdateCommand="Update Panier SET qtt=@qtt,commentaires=@commentaires WHERE email=?"

DeleteCommand="delete from Panier where email=? and code=@code">

<SelectParameters>

<asp:SessionParameter Name="?" SessionField="email" />

</SelectParameters>

</

asp:SqlDataSource>

Voici votre panier :

<br />

<br />

<asp:GridView ID="Grille_Panier" runat="server" AllowPaging="True" AllowSorting="True"

AutoGenerateColumns="False" DataSourceID="SQL_Panier">

<Columns>

<asp:CommandField ShowSelectButton="True" />

<asp:CommandField ShowEditButton="True" />

<asp:CommandField ShowDeleteButton="True" />

<asp:BoundField DataField="code" HeaderText="code" SortExpression="code" ReadOnly="True" />

<asp:BoundField DataField="courte" HeaderText="courte" SortExpression="courte" ReadOnly="True" />

<asp:BoundField DataField="qtt" HeaderText="qtt" SortExpression="qtt" />

<asp:BoundField DataField="prixttc" HeaderText="prixttc" SortExpression="prixttc" ReadOnly="True" />

<asp:BoundField DataField="commentaires" HeaderText="commentaires" SortExpression="commentaires" />

</Columns>

<EmptyDataTemplate>

Actuellement, votre panier ne contient aucun produit.

</EmptyDataTemplate>

</asp:GridView>

 

 

 

The select command works but not the update command!!!!

Can you help me please?

 

Thanks

0
jimmy28
8/7/2006 9:30:05 AM
asp.net.mysql 1929 articles. 0 followers. Follow

45 Replies
1144 Views

Similar Articles

[PageSpeed] 31

I tried to change "@qtt" in mys update command by a number like 5. And it works!!!!!

 

So the problem comes from the field I change in the gridview.

 

The parameter "@qtt" doesn't contain the value I just put in the textbox!!!!

0
jimmy28
8/20/2006 8:50:32 AM

I have the same problem.
The thing is that all the @DataField contains NULL.

If found that out when I tried this:

UpdateCommand="UPDATE titemgroup SET  Module=@Module, Title='test', Description=@Description  WHERE ItemGroupID=6"

All fields contained data before the Update-call, but afterwards Title was set to "test", Module and Description was NULL.

 

0
PeterCev
8/23/2006 2:01:35 PM

Tried the same calls using a MS Access db instead of MySQL and it all works... Very annoying.

Does anyone know how to get it to work with MySQL?

0
PeterCev
8/23/2006 2:23:49 PM

Right, MySQL does not support @.

Simply remove all @-signs in your sql-calls and it works like a charm.

like this:
UpdateCommand="Update Panier SET qtt=qtt,commentaires=commentaires WHERE email=?" DeleteCommand="delete from Panier where email=? and code=code">

I hope it works for you aswell.

0
PeterCev
8/23/2006 2:29:25 PM

Sorry, nevermind my last post...

I was a bit too fast and confused so I was still using the Access connection. Just ignore my last post as it's very wrong.

Sorry for that..

0
PeterCev
8/23/2006 2:55:45 PM

Does anybody know how can I get the modified value for a field?

 

If we can do that, we can build the query in vb and put it in the sqldatasource.

 

In sqldatasource_rowupdating event :

 

dim sql as string="Update Table set field1=" & ModifiedValue & " where field0=value"

sqldatasource.updatecommand=sql

 

 

0
jimmy28
8/24/2006 11:18:29 AM

You could try using the request obect. It goes something like:

<%= Request.Forms("itemName") %>

 Notice the field names in the actual posting HTML though,

<input name="GridView1$ctl04$ctl03" type="text" value="0" size="5" title="test2" />

 If you can't grab hold of the title name with the request object then you might just have to parse the column out of the name and go from there or maybe even try doing it by index #... can't remember all the ins and outs...

Also, just in case you don't know, turn on page tracing so you can see exactly what variable names the server is recievign on a post.

 Hope this helps.

 

0
aspcoder1234
8/29/2006 1:53:02 PM

I had been using the format '@variableName' but that doesn't work. Use a question mark ? by itself. It's kind of like a numbered array. The first ? is for the first parameter in the list, the second ? is for the second parament and so on. Here is some sample code that works for me:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT advertise4me.fsdfsdaf.* FROM advertise4me.fsdfsdaf"

UpdateCommand="UPDATE advertise4me.fsdfsdaf SET TESTDATA =? WHERE ID =?">

<UpdateParameters>

<asp:Parameter Name="TESTDATA" />

<asp:Parameter Name="ID" />

</UpdateParameters>

</asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">

<Columns>

<asp:CommandField ShowEditButton="True" />

<asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" />

<asp:BoundField DataField="TESTDATA" HeaderText="TESTDATA" SortExpression="TESTDATA" />

</Columns>

</asp:GridView> 

Oh, by the way, be careful of atributes to do with visibility and readonly... I don't have it figured out yet, but they block the variables from being posted or something.

Please let me know if this works.

 

 

 

0
aspcoder1234
8/29/2006 10:09:46 PM

This did not work for me, please help i cannot get mysql db to update.

<

asp:GridView ID="GridView1" AllowSorting="true" AllowPaging="false" Runat="server"

DataSourceID="SqlDataSource1" AutoGenerateEditButton="true" DataKeyNames="Team"

AutoGenerateColumns="False">

<Columns>

<asp:BoundField HeaderText="prid" DataField="prid" />

<asp:BoundField ReadOnly="true" HeaderText="Team" DataField="Team" />

<asp:TemplateField HeaderText="Rank" SortExpression="rank">

<ItemTemplate>

<asp:Label Runat="server" Text='<%# Bind("rank") %>' ID="label2"></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:DropDownList ID="ddlPr" runat="server" SelectedValue='<%# Bind("rank") %>' >

<asp:ListItem>1</asp:ListItem>

<asp:ListItem>2</asp:ListItem>

<asp:ListItem>3</asp:ListItem>

<asp:ListItem>4</asp:ListItem>

<asp:ListItem>5</asp:ListItem>

<asp:ListItem>6</asp:ListItem>

<asp:ListItem>7</asp:ListItem>

<asp:ListItem>8</asp:ListItem>

<asp:ListItem>9</asp:ListItem>

<asp:ListItem>10</asp:ListItem>

<asp:ListItem>11</asp:ListItem>

<asp:ListItem>12</asp:ListItem>

<asp:ListItem>13</asp:ListItem>

<asp:ListItem>14</asp:ListItem>

<asp:ListItem>15</asp:ListItem>

<asp:ListItem>16</asp:ListItem>

<asp:ListItem>17</asp:ListItem>

<asp:ListItem>18</asp:ListItem>

<asp:ListItem>19</asp:ListItem>

<asp:ListItem>20</asp:ListItem>

<asp:ListItem>21</asp:ListItem>

<asp:ListItem>22</asp:ListItem>

<asp:ListItem>23</asp:ListItem>

<asp:ListItem>24</asp:ListItem>

<asp:ListItem>25</asp:ListItem>

<asp:ListItem>26</asp:ListItem>

<asp:ListItem>27</asp:ListItem>

<asp:ListItem>28</asp:ListItem>

<asp:ListItem>29</asp:ListItem>

<asp:ListItem>30</asp:ListItem>

</asp:DropDownList>

</EditItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<br />

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:testConnectionString %>"

ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>"

SelectCommand="Select prid, team, rank, wins, loses, ties, otl, comment from power_rankings_holder"

UpdateCommand="UPDATE power_rankings_holder SET rank = ? WHERE prid = ?" >

<UpdateParameters>

<asp:Parameter name="rank" />

<asp:Parameter name="prid" />

</UpdateParameters>

</asp:SqlDataSource>
0
Horizon
1/12/2007 5:40:22 PM

This did not work for me, please help i cannot get mysql db to update.

<

asp:GridView ID="GridView1" AllowSorting="true" AllowPaging="false" Runat="server"

DataSourceID="SqlDataSource1" AutoGenerateEditButton="true" DataKeyNames="Team"

AutoGenerateColumns="False">

<Columns>

<asp:BoundField HeaderText="prid" DataField="prid" />

<asp:BoundField ReadOnly="true" HeaderText="Team" DataField="Team" />

<asp:TemplateField HeaderText="Rank" SortExpression="rank">

<ItemTemplate>

<asp:Label Runat="server" Text='<%# Bind("rank") %>' ID="label2"></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:DropDownList ID="ddlPr" runat="server" SelectedValue='<%# Bind("rank") %>' >

<asp:ListItem>1</asp:ListItem>

<asp:ListItem>2</asp:ListItem>

<asp:ListItem>3</asp:ListItem>

<asp:ListItem>4</asp:ListItem>

<asp:ListItem>5</asp:ListItem>

<asp:ListItem>6</asp:ListItem>

<asp:ListItem>7</asp:ListItem>

<asp:ListItem>8</asp:ListItem>

<asp:ListItem>9</asp:ListItem>

<asp:ListItem>10</asp:ListItem>

<asp:ListItem>11</asp:ListItem>

<asp:ListItem>12</asp:ListItem>

<asp:ListItem>13</asp:ListItem>

<asp:ListItem>14</asp:ListItem>

<asp:ListItem>15</asp:ListItem>

<asp:ListItem>16</asp:ListItem>

<asp:ListItem>17</asp:ListItem>

<asp:ListItem>18</asp:ListItem>

<asp:ListItem>19</asp:ListItem>

<asp:ListItem>20</asp:ListItem>

<asp:ListItem>21</asp:ListItem>

<asp:ListItem>22</asp:ListItem>

<asp:ListItem>23</asp:ListItem>

<asp:ListItem>24</asp:ListItem>

<asp:ListItem>25</asp:ListItem>

<asp:ListItem>26</asp:ListItem>

<asp:ListItem>27</asp:ListItem>

<asp:ListItem>28</asp:ListItem>

<asp:ListItem>29</asp:ListItem>

<asp:ListItem>30</asp:ListItem>

</asp:DropDownList>

</EditItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<br />

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:testConnectionString %>"

ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>"

SelectCommand="Select prid, team, rank, wins, loses, ties, otl, comment from power_rankings_holder"

UpdateCommand="UPDATE power_rankings_holder SET rank = ? WHERE prid = ?" >

<UpdateParameters>

<asp:Parameter name="rank" />

<asp:Parameter name="prid" />

</UpdateParameters>

</asp:SqlDataSource>
0
Horizon
1/12/2007 5:40:23 PM

I figured it out and I am pasting my aspx code here for future people who search and find this thread....

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:testConnectionString %>"

ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>"

DeleteCommand="DELETE from power_rankings_holder where prid = ?prid"

InsertCommand="INSERT into power_rankings_holder rank values(?rank)"

SelectCommand="SELECT prid, team, rank, wins, loses, ties, otl, comment from power_rankings_holder"

UpdateCommand="UPDATE power_rankings_holder SET rank = ?rank, comment = ?comment WHERE prid = ?prid" >

<UpdateParameters>

<asp:Parameter name="?rank" Direction="Input" />

<asp:Parameter name="?comment" Direction="Input" Type="string" />

<asp:Parameter name="?prid" Direction="Input" />

</UpdateParameters>
0
Horizon
1/15/2007 3:43:29 PM

Hello Horizon!

I tried your solution but i can't get it to work. I get an error message from Mysql that says:

ERROR [42S21] [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Unknown column 'NULLUID' in 'where clause' .

 UID is the table column and the name of the bound column in the grid. It seems as ASP converts the "? to a NULL value. Have you got any idea of what my problem is?

 

 

Horizon:

I figured it out and I am pasting my aspx code here for future people who search and find this thread....

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:testConnectionString %>"

ProviderName="<%$ ConnectionStrings:testConnectionString.ProviderName %>"

DeleteCommand="DELETE from power_rankings_holder where prid = ?prid"

InsertCommand="INSERT into power_rankings_holder rank values(?rank)"

SelectCommand="SELECT prid, team, rank, wins, loses, ties, otl, comment from power_rankings_holder"

UpdateCommand="UPDATE power_rankings_holder SET rank = ?rank, comment = ?comment WHERE prid = ?prid" >

<UpdateParameters>

<asp:Parameter name="?rank" Direction="Input" />

<asp:Parameter name="?comment" Direction="Input" Type="string" />

<asp:Parameter name="?prid" Direction="Input" />

</UpdateParameters>
0
ASPMatte
1/19/2007 11:09:33 AM
Sounds like you need single tick marks around the ?UID in your query....try that and see if it works.  What data type is UID?
0
Horizon
1/24/2007 9:08:27 PM
No, it doesn't work. What development environment do you use?
0
ASPMatte
1/26/2007 8:36:34 AM

I am using Visual Studio 2005 / ASP 2.0 and mySQL 5 I believe.

I am also using a mySQL .net Connector 5.0 from mysql's site

0
Horizon
1/26/2007 6:59:06 PM

nothing worked for me :(

any solution?!

0
dark_angle
2/17/2007 9:20:28 PM

This has been bugging me for a few days now as I too have got into the same problem.  However, the posts in this thread have helped me sort it out and get my GridView working, and this is what I did.

Although I haven't found direct information on the '@' not working with MySQL queries, it definitely doesn't work for me.  So that leaves the '?' notation and UpdateParameters tags, which works for me with the code below.  Hope this helps someone else.

 

"SqlDataSource1" runat="server" ConnectionString="&lt;%$ ConnectionStrings:myConnectionString %>"
            ProviderName="&lt;%$ ConnectionStrings:myConnectionString.ProviderName %>"
            SelectCommand="SELECT DISTINCT ClientID, Company, Name, Address1, Address2, City, State, ZIP, CountryCode, Email, Phone, Fax, WebSite FROM client ORDER BY Company"
            UpdateCommand="UPDATE client SET Company=?, Name=?, Address1=?, Address2=?, City=?, State=?, ZIP=?, CountryCode=?, Phone=?, Fax=?, WebSite=?, Email=? WHERE ClientID=?"
            DeleteCommand="DELETE FROM client WHERE ClientID=?">
        
            "String" Name="Company" Direction="Input">
            "string" Name="Name" Direction="Input">
            "string" Name="Address1" Direction="Input">
            "string" Name="Address2" Direction="Input">
            "string" Name="City" Direction="Input">
            "string" Name="State" Direction="Input">
            "string" Name="ZIP" Direction="Input">
            "string" Name="CountryCode" Direction="Input">
            "string" Name="Phone" Direction="Input">
            "string" Name="Fax" Direction="Input">
            "string" Name="WebSite" Direction="Input">
            "string" Name="Email" Direction="Input">
            "string" Name="ClientID" Direction="Input">
        
        
 
 

 



 

0
H0Ju
2/20/2007 6:52:53 PM

Sorry about that I would have thought the "Source Code" button in the WYSIWYG would actually do something nice...here's the direct copy & paste of the code :

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:myConnectionString %>"
            ProviderName="<%$ ConnectionStrings:myConnectionString.ProviderName %>"
            SelectCommand="SELECT DISTINCT ClientID, Company, Name, Address1, Address2, City, State, ZIP, CountryCode, Email, Phone, Fax, WebSite FROM client ORDER BY Company"
            UpdateCommand="UPDATE client SET Company=?, Name=?, Address1=?, Address2=?, City=?, State=?, ZIP=?, CountryCode=?, Phone=?, Fax=?, WebSite=?, Email=? WHERE ClientID=?"
            DeleteCommand="DELETE FROM client WHERE ClientID=?">
        <UpdateParameters>
            <asp:Parameter Type="String" Name="Company" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="Name" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="Address1" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="Address2" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="City" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="State" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="ZIP" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="CountryCode" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="Phone" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="Fax" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="WebSite" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="Email" Direction="Input"></asp:Parameter>
            <asp:Parameter Type="string" Name="ClientID" Direction="Input"></asp:Parameter>
        </UpdateParameters>
 </asp:SqlDataSource>

 

0
H0Ju
2/20/2007 6:56:45 PM

Thanks also to previous posters I got this working for both update and delete code is below hope it helps (ODBC connection used).

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>"

ProviderName="<%$ ConnectionStrings:ConnectionString1.ProviderName %>"

SelectCommand="SELECT * FROM name"

DeleteCommand="DELETE FROM name WHERE id = ?"

UpdateCommand="UPDATE name SET fname = ? WHERE id = ?"

OldValuesParameterFormatString="{0}">

<DeleteParameters>

<asp:Parameter Name="id" Type="Int32" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="fname" Type="String" Direction="Input" />

<asp:Parameter Name="id" Type="Int32" Direction="Input" />

</UpdateParameters>

</asp:SqlDataSource>

 

0
TG57
10/30/2007 11:42:42 AM

Mister, Any solution about it ?


http://www.setbb.com/putainformatica/viewtopic.php?p=843
www.trabajobasura.com/solusoft
www.kiquenet.net/churrosoft
0
alhambraeidos
11/30/2007 1:20:35 PM

 hi, could you guys guide me on this one?

<

asp:SqlDataSource ID="SQL_Panier" runat=server ConnectionString="<%$ ConnectionStrings:Connection to NI %>" ProviderName="<%$ ConnectionStrings:Connection to NI.ProviderName %>" SelectCommand="selectcommand" UpdateCommand="Update Panier SET qtt=@qtt,commentaires=@commentaires WHERE email=?" DeleteCommand="delete from Panier where email=? and code=@code"> <SelectParameters> <asp:SessionParameter Name="?" SessionField="email" /> </SelectParameters>

</

asp:SqlDataSource>

 

the above is the posters original code, now im trying to implement  gridview + mysql implementation and im stuck in the ProviderName property. i have mysql connector 5.0.9 if i am not mistaken, and i have this line in my web.config <add name="ConnString" connectionString="Database=thechoirportal_dev;Data Source=localhost; User Id=root; Password=password"/>. now, i dont know what to put in the ProviderName property. i trie ProviderName="<%$ MySql.Data.MySqlClient%>" and this error shows --> the connection name 'ConnString:MySql.Data' was not found in the applications configuration or the connection is empty. i tried to make it ProviderName="MySql.Data.MySqlClient", now the error is --> Unable to find the  requested .Net Framework Data Provider. It may not be installed. i tried to do this --><%@ import Namespace="MySql.Data.MySqlClient" %> and still a no go. im not sure about the first error because i was able to use it throughout my project, except for this page. anybody please guide me. thank you in advance.

 

**errors are in bold fonts. 

0
pleigh
1/9/2008 3:56:00 PM

I had this same problem for a long time. Depending the way you define parameters in the UpdateParemeter collection, the update queries do not make it to the MySQL server. I activated the log option to see the queries executed and I realised that the update in some cases make it to the server but with all parameters with value NULL.

The solution I found to all problems related to updating a MySQL database using ASP.NET in VS.2005 and with Connector/NET 5.1.4 is the following:

1. The update query must have parameters defined as ?column_name. For example

update table set column1 = ?column1, column2 = ?column2 where ...

2. In Visual Studio, for the SqlDataSource UpdateQuery parameters collection you have to add one parameter for each parameter in the update query but the name of the parameter (and this is the key point) must be just the column name without the ?. This has to do with the way .NET assign values on bound fields (in my case I am using a FormView) to the parameter collection of the update query.

Using this, all my update queries make it to the server with the values in the formview fields.

I hope this may help. It dit in my case.

Saludos,

0
schido
1/12/2008 7:33:35 PM

Thank you schido.

I have been struggling with the update and because of your tip, got it working a few minutes ago.

Thank you again.

Sri
 

0
srinair
1/16/2008 10:13:10 AM

FYI: Here is complete reference code of two different ways to get MySQL (v 5.1.22) to work with the ASP 2.0 GridView (update and delete) using the MySQL Connector/ODBC 5.1 or the MySQL Connector/Net 5.1.4:

Here is how my table is defined in the MySQL catalog:

CREATE TABLE `tbltest` (
  `testId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `value1` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`testId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

Here are my connection strings in my web.config:

 <configuration><appSettings /><connectionStrings>
   <
add
       name="csMySQL_ConODBC51"
       connectionString="Dsn=test;uid=test;pwd=secret"
       providerName="System.Data.Odbc" />
   <
add
      name="csMySQL_ConNet514"
      connectionString="server=127.0.0.1;user id=test;Password=secret;persist security info=True;database=test;pooling=False;logging=True;use old syntax=False;ignore prepare=False"
      providerName="MySql.Data.MySqlClient" />
   </
connectionStrings>
   ...
</configuration>

 

Here is my ASP 2.0 code snippet 1.  Note: the MySQL Connector/ODBC 5.1 connection, the use of only the '?' in the XXXCommands and the lack of the <DeleteParameters> & <UpdateParameters> tags.

<asp:SqlDataSource

    ID="dsMySQL"

    runat="server"

    ConnectionString="<%$ ConnectionStrings:csMySQL_ConODBC51%>"

    ProviderName="<%$ ConnectionStrings:csMySQL_ConODBC51.ProviderName %>"

    SelectCommand="SELECT testId, value1 FROM tbltest"

    UpdateCommand="UPDATE tbltest SET value1=? WHERE testId=?"

    DeleteCommand="DELETE FROM tbltest WHERE testId=?">

</asp:SqlDataSource>

 

<asp:GridView

    ID="gv1"

    runat="server"

    AutoGenerateColumns="False"

    DataKeyNames="testId"

    DataSourceID="dsMySQL">

    <Columns>

        <asp:CommandField ShowEditButton="True" />

        <asp:CommandField ShowDeleteButton="True" />

        <asp:BoundField

            DataField="testId"

            HeaderText="PK Id"

            InsertVisible="False"

            ReadOnly="True"

            SortExpression="testId" />

        <asp:BoundField

            DataField="value1"

            HeaderText="Col 1 Value"

            SortExpression="value1" />

    </Columns>

</asp:GridView>

 

 

Here is my ASP 2.0 code snippet 2.  Note: the MySQL Connector/Net 5.1.4 connection, the use of '?' preceding the params in the XXXCommands but NOT in the Name definition of the <DeleteParameters> & <UpdateParameters> tags:

 

<asp:SqlDataSource

    ID="dsMySQL"

    runat="server"

    ConnectionString="<%$ ConnectionStrings:csMySQL_ConNet514%>"

    ProviderName="<%$ ConnectionStrings:csMySQL_ConNet514.ProviderName %>"

    SelectCommand="SELECT testId, value1 FROM tbltest"

    UpdateCommand="UPDATE tbltest SET value1=?value1 WHERE testId=?testId"

    DeleteCommand="DELETE FROM tbltest WHERE testId=?testId">

 

    <DeleteParameters>

        <asp:Parameter Name="testId" Type="UInt32" />

    </DeleteParameters>

    <UpdateParameters>

        <asp:Parameter Name="testId" Type="UInt32" />

        <asp:Parameter Name="value1" Type="String" />

    </UpdateParameters>

</asp:SqlDataSource>

 

<asp:GridView

    ID="gv1"

    runat="server"

    AutoGenerateColumns="False"

    DataKeyNames="testId"

    DataSourceID="dsMySQL">

    <Columns>

        <asp:CommandField ShowEditButton="True" />

        <asp:CommandField ShowDeleteButton="True" />

        <asp:BoundField

            DataField="testId"

            HeaderText="PK Id"

            InsertVisible="False"

            ReadOnly="True"

            SortExpression="testId" />

        <asp:BoundField

            DataField="value1"

            HeaderText="Col 1 Value"

            SortExpression="value1" />

    </Columns>

</asp:GridView>

 

Hope the info helps:

 

Cheers,

Al Dass


Cheers,

Al Dass
0
AlDass
1/16/2008 5:11:26 PM

Thanx Al DASS..your post above really helps me..thanx again man..

:))

0
kakibola
2/18/2008 3:33:14 AM

 Nice Al Dass that was really helpful

0
graljackal
5/3/2008 3:17:26 PM

Like others in this thread I am trying to use a SqlDataSource for displaying and editing data from a Mysql DB.  I can display the data in a Gridview ok.  The SELECT and UPDATE commands are working. But I can't get the DELETE and INSERT commands to work.  I am using a MySQL ODBC 3.51 Driver as per my web host.    

The DELETE erro is: SQLBindParameter not used for all parameters

The INSERT error is: Column count doesn't match value count at row 1 [The "id" column is primary but not auto incremented]

I think I have tried all the variations in this thread.  Any help would be greatly appreciated.  Here is my code for the SqlDataSource.

<asp:SqlDataSource ID="SDS1"

runat="server"

ConnectionString="<%$ ConnectionStrings:MySQL_ODBC %>"

ProviderName="<%$ ConnectionStrings:MySQL_ODBC.ProviderName %>"

SelectCommand="SELECT * FROM zen_orders"

UpdateCommand="UPDATE zen_orders SET name=? WHERE id=?"

DeleteCommand="DELETE FROM zen_orders WHERE id=?"

InsertCommand="INSERT INTO zen_orders (id, name) VALUES ('id?, name?')">

<DeleteParameters>

<asp:Parameter Name="id" Type="Int32" Direction="InputOutput" />

<asp:Parameter Name="name" Type="String" Direction="InputOutput" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="name" Type="String" Direction="Input" />

<asp:Parameter Name="id" Type="Int32" Direction="Input" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="id" Type="Int32" Direction="Input" />

<asp:Parameter Name="name" Type="String" Direction="Input" />

</InsertParameters>

</asp:SqlDataSource>

 

0
Moonshadow
7/16/2008 8:11:40 PM

I posted a full example (see http://forums.asp.net/p/1015092/2494450.aspx#2494450) for use with ODBC.

Anyway, I think the major issue is the comment from my post:

Note: the MySQL Connector/ODBC 5.1 connection, the use of only the '?' in the XXXCommands and the lack of the <DeleteParameters> & <UpdateParameters> tags.


Cheers,

Al Dass
0
AlDass
7/16/2008 10:26:28 PM

Hi Al Dass.  Thanks for your input.  As I noted, I believe I have tried about all of the options presented in this thread and the code I cited above seemed to work for SELECT and UPDATE. 

 

I think this is probably the version that comes closest to what you have advised:

 <asp:SqlDataSource ID="SDS1"        runat="server"         ConnectionString="<%$ ConnectionStrings:MySQL_ODBC %>"        ProviderName="<%$ ConnectionStrings:MySQL_ODBC.ProviderName %>"        SelectCommand="SELECT * FROM zen_orders"        UpdateCommand="UPDATE zen_orders SET name=? WHERE id=?"        DeleteCommand="DELETE FROM zen_orders WHERE id=?"        InsertCommand="INSERT INTO zen_orders (id, name) VALUES (id?, 'name?')">

     </asp:SqlDataSource>

 

The DELETE, UPDATE, and INSERT do not work.  Here are the errors:

 

DELETE:  “SQLBindParameter not used for all parameters”

 

INSERT: “ERROR [23000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''44', 'name?')' at line 1”

 

UPDATE (Edit): No error message but the word “name” was put into the “id” field for every row in the table (ouch!!).

 

0
Moonshadow
7/17/2008 12:29:19 AM

It's complaining about the data bindings and that part is missing... post your aspx GridView code.  Also, to be sure its not with your setup, have you been able to get the example I posted working on your system?


Cheers,

Al Dass
0
AlDass
7/18/2008 8:19:09 PM

Here is the complete page code.  It loads with data ok, but throws the errors as noted previously when I try to update, delete, or insert.  Thanks for your input. Hope we can get this working.

<%@ Page Language="VB" Debug="true" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:GridView ID="GridView1" runat="server" DataSourceID="SDS1" AllowPaging="True" AllowSorting="True">

<Columns>

<asp:CommandField ShowSelectButton="True" ShowDeleteButton="True" ShowEditButton="True" />

</Columns>

</asp:GridView> &nbsp;

<asp:SqlDataSource ID="SDS1"

runat="server"

ConnectionString="<%$ ConnectionStrings:MySQL_ODBC %>"

ProviderName="<%$ ConnectionStrings:MySQL_ODBC.ProviderName %>"

SelectCommand="SELECT * FROM zen_orders"

UpdateCommand="UPDATE zen_orders SET name=? WHERE id=?"

DeleteCommand="DELETE FROM zen_orders WHERE id=?"

InsertCommand="INSERT INTO zen_orders (id, name) VALUES (id?, 'name?')">

</asp:SqlDataSource>

<br /><br />

<asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" AllowPaging="True" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" DataSourceID="SDS1">

<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />

<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />

<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />

<Fields>

<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />

</Fields>

<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />

<EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />

</asp:DetailsView>

</div>

</form>

</body>

</html>

0
Moonshadow
7/18/2008 8:41:07 PM

HI, ASPMatte

 I think this is ODBC driver bug.

I sugggest to use mysql.net driver (from http://dev.mysql.com/downloads/connector/net/5.1.html) instead of ODBC, because odbc is slow, it doesn't support all features of mysql server. It also comes with integration with Visual studio.

 


Sharique udddin Ahmed Farooqui
Web Developer

Please mark it as answer if it resolves the issue.
0
safknw
7/20/2008 5:40:56 PM

Thanks for the suggestion.  I downloaded that driver, registered the binaries, and placed them in the bin folder.  I added the namespace to the page and adjusted my previous ODBC connection string, but got this error:

Compiler Error Message: BC30002: Type 'MySqlCommand' is not defined.

Here is the relevant code:

<%@ Page Language="VB" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="Mysql.Data.Mysqlclient" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Dim cmd As MySqlCommand = New MySqlCommand("Select * from zen_orders", New MySqlConnection("DRIVER={MySQL Connector Net 5.1.6 Driver};SERVER=XXXX.secureserver.net;PORT=3306;DATABASE=XXXX;USER=XXXX;PASSWORD=XXXX;OPTION=0;"))

Try

cmd.Connection.Open()

gvwExample.DataSource = cmd.ExecuteReader()

gvwExample.DataBind()

cmd.Connection.Close()

cmd.Connection.Dispose()

Catch ex As Exception

lblStatus.Text = ex.Message

End Try

End Sub

</script>

Since I registered the namespace and there are no indications of coding errors on the page, I am not sure how I can appropriately define the MySqlCommand.  Any further suggestions?

0
Moonshadow
7/20/2008 7:42:30 PM

You have no bound columns in the gridView... hence the errors you are getting (in your prev post).


Cheers,

Al Dass
0
AlDass
7/22/2008 12:04:24 AM

Here is my complete page code.  The bound columns were coded into the Gridview in the body of the page:

<%@ Page Language="VB" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="Mysql.Data.Mysqlclient" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Dim cmd As MySqlCommand = New MySqlCommand("Select * from zen_orders", New MySqlConnection("SERVER=xxxx.secureserver.net;PORT=3306;DATABASE=xxxx;USER=xxxx;PASSWORD=xxxx;OPTION=0;"))

Try

cmd.Connection.Open()

gvwExample.DataSource = cmd.ExecuteReader()

gvwExample.DataBind()

cmd.Connection.Close()

cmd.Connection.Dispose()

Catch ex As Exception

lblStatus.Text = ex.Message

End Try

End Sub

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:GridView ID="gvwExample" runat="server" AutoGenerateColumns="False" CssClass="basix" CellPadding="4" ForeColor="#333333" GridLines="None" >

<columns>

<asp:BoundField DataField="id" HeaderText="ID" />

<asp:BoundField DataField="name" HeaderText="Name" />

</columns>

<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />

<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />

<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />

<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />

<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />

<AlternatingRowStyle BackColor="White" />

</asp:GridView>

<br /><br />

<asp:Label ID="lblStatus" runat="server" Text=""></asp:Label>

<br />

</div>

</form>

</body>

</html>

 

 

0
Moonshadow
7/22/2008 9:21:11 AM

try adding the DataKeyNames ="id" attribute to the asp:GridView element


Cheers,

Al Dass
0
AlDass
7/23/2008 5:24:35 AM

Tried it.  Still getting: "Compiler Error Message: BC30002: Type 'MySqlConnection' is not defined."

0
Moonshadow
7/23/2008 8:22:02 AM

Sometimes the VS IDE gets confused... try creating a new connection string and using that instead.


Cheers,

Al Dass
0
AlDass
7/24/2008 7:08:10 AM

Created new connection string. Same error message.

0
Moonshadow
7/24/2008 12:57:42 PM

 I know this thread is old, but I stumbled on it during a search for problems I was having with MySQL and GridView.  Thanks to Al Dass, I was able to solve my problems!  I did want to post some additional info in case others run across it.  As I added columns to the GridView and my UPDATE statement, it stopped updating when it came to one column.

I used  the syntax that Al posted for ODBC 5.1 connection.  However, I did run across a problem with mixed string and int columns (in particular, one that was set to an int(4) type in MySQL).  I had to go into the  properties for that column and set the DataFormatString to a numeric general format value (I know, it seems so obvious now).

This value is for a time out in some automation I'm working on. It looks like.

                <asp:BoundField DataField="time_out" DataFormatString="{0:G}" 
                    HeaderText="time_out" SortExpression="time_out" />
So, if you're mixing strings and INTs, you may need to format the value if you're having problems.

Sax

 

 

 

0
Saxmoore
3/24/2009 2:50:59 AM

 Hey Sax,

Thx for the kudos... and also for the info about mixed string/int columns... that bit me a while back and I don't remember how I solved it (I know it was probably not prettyEmbarrassed) but now I do... thx.

 

Cheers,

 Al Dass


Cheers,

Al Dass
0
AlDass
3/31/2009 5:27:26 PM

 What's funny (and frustrating) about this is....I ran into a few days later...AGAIN!  I refreshed the schema of the form in design view and scratched my head for a bit until I realized that I needed to go back and set the formatting.  Surprise  But, GridView and DetailsView are all working and happy together, now.

Thanks, Al!

0
Saxmoore
3/31/2009 5:52:31 PM

Master ALDass , a little out of the time , but thank you very much for your previews detailed and methodic post , I found them very useful using VS 2008 with .NET 3.5 , I simply added the following to the defaulfs of the Wizards :

- DatakeyName is the Gridview command

- Referr to the MySQL field as id=?id for example.

 Follow this thread for all people who are using VS 2008

0
river_plate
4/3/2009 10:55:30 PM

schido:

I had this same problem for a long time. Depending the way you define parameters in the UpdateParemeter collection, the update queries do not make it to the MySQL server. I activated the log option to see the queries executed and I realised that the update in some cases make it to the server but with all parameters with value NULL.

The solution I found to all problems related to updating a MySQL database using ASP.NET in VS.2005 and with Connector/NET 5.1.4 is the following:

1. The update query must have parameters defined as ?column_name. For example

update table set column1 = ?column1, column2 = ?column2 where ...

2. In Visual Studio, for the SqlDataSource UpdateQuery parameters collection you have to add one parameter for each parameter in the update query but the name of the parameter (and this is the key point) must be just the column name without the ?. This has to do with the way .NET assign values on bound fields (in my case I am using a FormView) to the parameter collection of the update query.

Using this, all my update queries make it to the server with the values in the formview fields.

I hope this may help. It dit in my case.

Saludos,

This was a key to solving my problem, which is updating a FormView using the ODBC connection to a remote server MySql database.   The server's MySql version, or my MySql ODBC provider version may be different from what you used.  Anyway, I found I had to modify slightly from your recipe:

Instead of "?column1" I had to use just the "?" in the SQL UPDATE command.   The key requirement, as you said, is the name of the asp:parameter being just the column name without the ?. 

 Also, I don't know if this was true in your case but the order of the asp:parameter elements has to match the order of the '?" in the UPDATE command.

 Edit: Just realized schido was using the MySql Connector /Net instead of the ODBC connector, which probably explains the differences.

0
dlflannery
5/2/2009 5:04:46 PM

 Sorry I never followed up on your last post... did you ever get it solved?


Cheers,

Al Dass
0
AlDass
5/3/2009 11:45:43 PM
Reply:

Similar Artilces:

MySQL
Currently have a site coded in PHP but the customer wants to go to .NET. Can I use the existing MySQL DB or am I required to use MSSQL? Thanks, Ken Check out this forum which is specialized for this kind of questions: ASP.NET MySQL forumBart De Smet [MVP] Visit www.msdn.be, www.bartdesmet.net...

GridView-Mysql-bind Gridview control to SqlDataSource -problem-Delete Command
 DeleteCommand="DELETE FROM relatorios WHERE codigo=codigo"> this works but delete everythingi have tryed thisWHERE codigo='codigo' ">and WHERE codigo=?codigo"> sintax error on mysql the full code is below :  <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" CellPadding="4" DataKeyNames="codigo"  AutoGenerateDeleteButton="True"  DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="Non...

Updating Gridview with SqlDataSource with MySQL
Hey guys,Got one problem thats really making me tear out my hair. i know this may be simple for you guys, but its completely got me stumped.. i'm really appreciate f this forum and the users who helped me in the past, it really has helped me out in tight situations. Here's the problem, i have a populated gridview that has a single column (UserStatus) that i want to editable, the edit and cancel buttons both work, but i can't seem to update the single record that i updated without the whole column in the gridview getting updated to the same value that i put into the single one.. i...

mysql php5-mysql
Hi, i have installed mysqk from binaries itworks!!! but now how can i install php5-mysql and dependencies? Many thanks Thierry -- trazomtg ------------------------------------------------------------------------ When you say from the binaries, do you mean you installed via Yast and the Suse repositories?? It is always best to install via Yast-Software-Software Management if you can. This way all dependencies are done for you. -- gogalthorp ------------------------------------------------------------------------ gogalthorp's Profile: http://forums.opensuse....

Any Grid for MySQL in .Net except the gridview in VS2005???
i using Connector 5.0.7, and if i use gridview to display the db data,the sorting,paging function all cant be use. any other tools to intro ? which can support for MySQL paging,sorting and other function. i found RadGrid, http://www.telerik.com/demos/aspnet/Grid/Examples/Programming/SimpleBinding/DefaultCS.aspx but i not sure it can fully utilize under MySQL or not? anyone try it before?C####################################### No one can help???C#######################################...

MySql, SqlDataSource, GridView, & VWD 2008 Express
Good afternoon, everyone.  I am new to the forums, though not to the site.  I *FINALLY* have a project that I can use to learn more about asp.net, albeit a home project.  I have created a MySQL database called "media" which will house all of my digital media (music, audiobooks, etc) as well as potentially my DVD & book collection.  The first table to have data is the "music" table, which contains the following columns:DROP TABLE IF EXISTS `media`.`music`;CREATE TABLE  `media`.`music` (  `music_id` smallint(5) unsigned NOT NULL AUTO_INCREM...

SqlDataSource and MySql
How I configure SqlDataSource to work with MySql .Net Connector 1.0.6 in VWD? Please!! Thks! Ubiratã I'm not sure it will work, but have You tried something like this: <%@ Page Language="C#" %> <%@ Import Namespace="System" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.Odbc" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> protected void Page_Load(object sender, EventArgs e) { } </script> <html ...

SQLDataSource for MySQL
How do you use FormView and SQLDataSource to insert and update a MySQL database? Because when i configure my SQLDataSource i can't even generate the insert/update/delete statements automatically even with all of the fields selected. Thanks Whould it be in the way of stored proceedures would they help me?...

MySQL and Gridview
Dear All,  I would like to use the MySQL .net connector to connect to my MySQL database. I can get the connection set up and display data from a table using the Gridview. But, I cannot control the layout options such as paging, insertion, editing and deletion. Is there a way that this can be achieved? The code that I have been using to connect to my MySQL database is below:  <%@ Page Language="VB" debug="true" %> <%@ Import Namespace = "System.Data" %> <%@ Import Namespace = "MySql.Data.MySqlClient" %><script languag...

linked server MySql to Mysql
Can i make linked server from MySql to another Mysql server?...

mysql and .net
Hi there, i am new to .net and i am trying to setup a simple form. I am an open source person and what i am asking can be done easily using php and mysql; but i need to know how to do this in .net project asap. i have three forms; form1 submit to the database and redirect to form2 and form2 submit to the database and redirect to form3. i want to grab mysql last inserted id from form1 to form2 while redirecting and pass it via the url. i am able to select from the database, but i don't know how to assign it to a variable; here is what i have so far: str2 = "select last_ins...

Net::MySQL
------=_NextPart_000_0026_01C30A6E.486AE070 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Anyone run into this problem=20 $mysql->query(q{ INSERT INTO dbname (table_name) VALUES ( $var ) }); The problem is, when I assign a value to a $var that value is ignored in = the SQL statement. Ive tried every operator I know to get it to look at = it and accept the value as input into the DB. Ive tried=20 ( '$var' ) ("$var") ("\$var") ([$var]) ({$var}) Any ideas ? Kind regards...

Suse MySQL and MySQL workbench
I am looking at the downloads here 'MySQL :: Download MySQL Workbench' (http://dev.mysql.com/downloads/workbench/1.0.html#downloads) and 'MySQL :: Download MySQL Community Server' (http://dev.mysql.com/downloads/mysql/#downloads). As one is source code and the other is suse enterprise linux, are these the best downloads for MySQL on suse 11.3? Is there a best source for the install? Suse specific rpm's? -- flebber ------------------------------------------------------------------------ Try zypper or YAST first to look at the OpenSuSE repositories. ...

DBD::mysql bad auto/DBD/mysql/mysql.bundle file on OS X
Howdy group :) Having a bit of trouble getting DBD::mysql installed on OS X I get this error: root# perl -e 'use DBD::mysql;' Can't load '/Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: /Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle(2): Not a recognisable object file at -e line 1 Compilation failed in require at -e line 1. BEGIN failed--compilation aborted at -e line 1. root# Here is what is in the directory: root# ls /Library/Perl/5.8.1/darwin-thread-multi-2level/au...

Web resources about - SQLdatasource + gridview + mysql - asp.net.mysql

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Using The LINQDataSource
-*+There is a new datasource control available in Visual Studio that works in much the same way as the SQLDataSource and the ObjectDataSource. ...

Gabriel Mongeon
Archive - Gabriel Mongeon

moredotnet
M ore d otnet .NET Interview Questions, ASP.NET, C#, VB.NET, XML, SQL Check Out http://www.dotnetUncle.com √ .NET NOTES OOPS in .NET .NET ...

Architectural Overview of the Windows Presentation Foundation Beta 1 Release
Introduction Windows Presentation Foundation Beta 1 Windows Integration New Features WinFX SDK Exploring the New Features Introducing "Express" ...

About Mikesdotnetting
I started this site as somewhere to store answers to bits and pieces that I see asked frequently in the forums at www.asp.net . Rather than type ...

Using MiniProfiler with SqlDataSource ASP.NET WebForms Control
public class ProfiledSqlDataSource : SqlDataSource{ protected override DbProviderFactory GetDbProviderFactory() { // get the "base" DbProviderFactory ...

ASP.NET Pivot Table - RadPivotGrid for ASP.NET AJAX
... reports. RadPivotGrid allows easy customization of all data reports. Try now! Use any declarative data source control (AccessDataSource, SqlDataSource, ...

Sign on
Sign On • Join • Forums Home User Name * Password * Remember me next time ( I forgot my password ) SUBMIT YOUR WTF Content Random Article All ...

ComboBox Sample
ComboBox is an ASP.NET AJAX control that, like the AutoCompleteExtender , combines the flexibility of a TextBox with a list of options that users ...

Resources last updated: 12/21/2015 9:10:28 PM