MySQL

SQLdatasource + gridview + mysql

jimmy28 — Mon, 07 Aug 2006 09:30:05 GMT

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">

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

</SelectParameters>

asp:SqlDataSource>

Voici votre panier :

<br />

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

AutoGenerateColumns="False" DataSourceID="SQL_Panier">

<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>

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

Extract the first sentance from a field in mqsql database - asp.net

binnsy87 — Wed, 25 Nov 2009 02:44:51 GMT

Hello People,

I am creating a news website which displays news headlines which are hyperlinked, when a specific headline is click it goes to another page which displays the full article...

My question is : on the main page where the headlines display, I want to show the first sentance of the article underneath so the reader can see what the articles aboutI have a grideview on my page but am not sure how to just show the first sentance of the article instead of the full thing withought putting the first sentance in a seperate field...

Any help would be greatly appreciated

Marc

Need help - alter time stamps based on time record written

bbcompent1 — Thu, 05 Nov 2009 18:50:50 GMT

Ok, let me see if I can make this understandable in human language.

I have a table that gets written into in batches of 30 records every 2 1/2 hours by cellular modem. There is currently a procedure that parses these batch records into individual records. The problem is the time and date on the records is wrong. However, I am capturing the time at which the last record comes in. The readings are taken every five minutes.

What I'd like to know how to do is to take the time/date of the records and change their time based on the last record. Logically, this is how I envision this.

Batch gets written at 11-04-2009 13:47:52

Change time/date stamp on last record to match record written date.

For each previous record, subtract 5 minutes from last record to correct the time/date stamp.

I've never written procedures for MySQL so I kinda feel like the village idiot here. Thanks :)

Establishing a database connection using Putty to tunnel over SSH

NicoleVT2000 — Tue, 24 Nov 2009 17:43:29 GMT

I currently have an ASP.NET web application that is using a MySQL database as the source data. I would like to connect to this database using the standard MySQL listening port of 3306 and tunnel the database connection over SSH (Port 22). I have Putty on my Web server and will configure Putty to do Port Redirection (3306 > 22 > 3306). I would like my web application to first open the Putty connection (somehow have my web application pass the credentials to the server via Putty) which would establish an SSH connection to the distant server. Once that SSH connection is established, I would then establish a standard MySQL database connection using a connection string. I would prefer not to leave the SSH connection open all the time and want Logi to handle both the SSH and database connection calls only when it is needed. This methodology of tunneling a database connection over SSH is not MySQL specific and could be used to securely tunnel any database connection. Has anyone done anything like this and if so could you provide me with how you had the web application establish these connection calls?

MySQL and timeout connection issues

learning.aspnet — Sun, 22 Nov 2009 05:19:17 GMT

Hello,

I am having terrible time. I have deployed my website. I have developed the website using ASP.NET 3.5 and the database used is MySQL. I have used MySQL Connector and have not used any DataSet.

Every morning when I wake up, I have got the below message:-

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

Then I replace one file (from App_Code) which shows the error to the server. and probably the connection pool is reset. The website then works fine. Obviously that is not a feasible solution.

I have looked for all leaked connections in the code but could not find any. I am closing all connections and datareader manually.
However, I found that I am passing DataReader as argument. But I believe since it is sent as reference, so I think I am here too.
I have noticed that I dont Dispose MySqlCommand object manually. Is this could be cause of the problem ?
I have tried to opened my instances ( I think 100+) on local machine but could not replicate it my end. How can I replicate this issue at my end ?
Does by copying a .cs file reset the connection pool ? Is my assumption correct ?

I am really having a tough time. Can somebody please help me. I shall be very grateful to him.

How to filter mysql data Row in asp.net?

Muhammad Kashan Khan — Tue, 26 May 2009 05:42:51 GMT

Hi there. I need to filter the Row from mySQL table. i m using _dv.RowFilter = "ResourceKey=" + mResourceKey + " AND ifnull(UR.SectionOptionID,0)<>0 AND isnull(SO.OptionTitle)"; but it is telling me that Ifnull and isnull not recognized function. what i do Plz help.

VS versional Support

kwcoffee1 — Fri, 20 Nov 2009 00:03:27 GMT

Hi,

Currently, I programming with VS2008 Standard. This version do not support the MySQL c/NET add-in. So, can I purchase the VS2010 Pro Upgrade version ? Moving form the Std to the Pro and 2008 to 2010.

Sincerely,

King

MySQL and timeout connection issues

learning.aspnet — Sun, 22 Nov 2009 07:36:31 GMT

Hello,

I am having terrible time. I have deployed my website. I have developed the website using ASP.NET 3.5 and the database used is MySQL. I have used MySQL Connector and have not used any DataSet.

Every morning when I wake up, I have got the below message:-

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

Then I replace one file (from App_Code) which shows the error to the server. and probably the connection pool is reset. The website then works fine. Obviously that is not a feasible solution.

I have looked for all leaked connections in the code but could not find any.I am closing all connections and datareader manually.
However, I found that I am passing DataReader as argument. But I believe since it is sent as reference, so I think I am fine here too.
I have noticed that I dont Dispose MySqlCommand object manually. Is this could be cause of the problem ?
I have tried to opened my instances ( I think 100+) on local machine but could not replicate it my end.
How can I replicate this issue at my end ? Does by copying a .cs file reset the connection pool ? Is my assumption correct ?

I am really having a tough time. Can somebody please help me. I shall be very grateful to him.

Plural search in mysql

senthilkumar.moorthy — Tue, 17 Nov 2009 11:24:04 GMT

consider a table have the record for both the "cover" and "covers" so,

when i do the like keyword search with "cover" text will return both the record that have cover,covers

but when i use like with "covers" it return only the record that have the text "covers" but i want return both .

How to update two tables using code behind/session vars

bbcompent1 — Mon, 16 Nov 2009 21:08:16 GMT

Hello all, I'm getting farther along but seem to have hit a snag. I am trying to update two tables when user hits submit button via code behind. I have my queries written and I've set the session vars so I can do an update query. The main problem I have is I am confused on how to do a query from code behind. I used to know but I've forgotten, guess the old don't use it you lose it story is true. Does anyone have a simple example of this? Any assistance would be greatly appreciated and thanks in advance.

Can't send parameters to a MySQL Stored Procedure

detzey — Tue, 13 Jan 2009 02:37:29 GMT

Hi everyone!

I'm having a problem to send parameters to MySQL Stored Procedure.

Here's the C# code:

1    using (MySqlConnection cn = new MySqlConnection(this.ConnectionString))
2    {
3        MySqlCommand cmd = new MySqlCommand("isy_Articles_InsertCategory", cn);
4        cmd.CommandType = CommandType.StoredProcedure;
5        cmd.Parameters.Add("?pAddedDate", MySqlDbType.DateTime).Value = category.AddedDate;
6        cmd.Parameters.Add("?pAddedBy", MySqlDbType.VarChar).Value = category.AddedBy;
7        cmd.Parameters.Add("?pTitle", MySqlDbType.VarChar).Value = category.Title;
8        cmd.Parameters.Add("?pImportance", MySqlDbType.Int32).Value = category.Importance;
9        cmd.Parameters.Add("?pImageUrl", MySqlDbType.VarChar).Value = category.ImageUrl;
10       cmd.Parameters.Add("?pDescription", MySqlDbType.VarChar).Value = category.Description;
11       cmd.Parameters.Add("?pCategoryID", MySqlDbType.Int32).Direction = ParameterDirection.Output;
12       cn.Open();
13       //int ret = ExecuteNonQuery(cmd);
14       //return Convert.ToInt32(cmd.Parameters["@CategoryID"].Value);
15       return ExecuteNonQuery(cmd);
16   }

Here's my stord procedure:

1    CREATE DEFINER=`institutosha`@`%` PROCEDURE `isy_Articles_InsertCategory`(
2    IN AddedDate DATETIME,
3    IN AddedBy VARCHAR( 256 ) ,
4    IN Title VARCHAR( 256 ) ,
5    IN Importance INT,
6    IN Description MEDIUMTEXT,
7    IN ImageUrl VARCHAR( 256 ) ,
8    OUT CategoryID INT)
9    BEGIN
10   
11   DECLARE pCurrID int;
12   
13   SELECT pCurrID = CategoryID
14   FROM isy_Categories
15   WHERE LOWER( pTitle ) = LOWER( Title ) ;
16   
17   IF pCurrID IS NOT NULL THEN
18   SET CategoryID = -1;
19   END IF;
20   
21   INSERT INTO isy_Categories(
22   AddedDate,
23   AddedBy,
24   Title,
25   Importance,
26   Description,
27   ImageUrl
28   )
29   VALUES (
30   AddedDate, AddedBy, Title, Importance, Description, ImageUrl);
31   
32   SET CategoryID = last_insert_id( ) ;
33   
34   END

 I had tried replacing the ? by @ or by nothing and none worked.

I'm using  MySQL 5.1 and MySQL Connector NET 5.1.7 with .NET Framework 2.0.

I have goggleed a lot and haven't found anything yet so I would be apreciate if someone helps me.

Thanks

asp.net gridview using mysql, Will not update if PK column is not visible

TinyPond — Thu, 19 Nov 2009 01:16:39 GMT

I have a asp.net webform on it I have a sqldatasource and a gridview that has two columns a primary key and a description . ( I have more columns in my gridview, however in debugging this ,I have reduced this problem down to two columns, a primary key and another column in order to keep this problem simple)

The problem I am having is I do not want to display the primary key since it is an autogenerated number and I do not want the user thinking they can change it.

However within my gridview In order for the save command to work I must add the following

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

This works!  and displays the two columns, but if I change the readonly propertly to true or set visible property to false
it will not work.
If I change the  boundField to a templateField it will not work either. So the only time I can get it to work is by making 
it a boundField and setting it to be visible.


If I add remove it will not save on update.


I have include a script to construct the table along with the code  that is not working and would appreciate if someone would provide some insight to this problem.

Just for fun I ran created a similar table in SQL SERVER and it the  ReadOnly="True"   and/or  Visible="false"
both work fine.

Not sure how everyone else is dealing with this problem
I am using the connector/Net 6.1 provider for mysql  http://dev.mysql.com/downloads/connector/net/6.1.html

MySQL Table

CREATE TABLE `tblCouponCampaignMaster` (
  `CampaignID` int(10) unsigned NOT NULL auto_increment,
  `Description` varchar(145) default NULL,
    PRIMARY KEY  (`CampaignID`),
) ENGINE=InnoDB AUTO_INCREMENT=2048 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;


Form1.Aspx

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:MyRastarConnectionStr %>"
        DeleteCommand="DELETE FROM tblCouponCampaignMaster  WHERE CampaignID = @CampaignID"
        InsertCommand="INSERT INTO tblCouponCampaignMaster (Description) VALUES (@Description)"
        

        ProviderName="<%$ ConnectionStrings:MyRastarConnectionStr.ProviderName %>"
        SelectCommand="SELECT CampaignID, Description
                       FROM stag_aff_rastar.tblCouponCampaignMaster;"
 
        UpdateCommand="UPDATE tblCouponCampaignMaster SET Description = @Description
                                                          WHERE CampaignID = @CampaignID">
        <DeleteParameters>
            <asp:Parameter Name="CampaignID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="CampaignID" Type="Int32" />
            <asp:Parameter Name="Description" Type="String" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="CampaignID" Type="Int32" />
            <asp:Parameter Name="Description" Type="String" />
           

           
        </InsertParameters>
    </asp:SqlDataSource>
    
    
     
    
    
    

    <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
        AllowSorting="True" CellPadding="4" DataSourceID="SqlDataSource1"
        ForeColor="#333333" PageSize="20"
        AutoGenerateColumns="False">
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
                ShowSelectButton="True" />
              <asp:BoundField HeaderText="CampaignID"
                 DataField="CampaignID"
                  SortExpression="CampaignID"></asp:BoundField>    
             <asp:BoundField HeaderText="Coupon Description"
                 DataField="Description"
                 SortExpression="Description"></asp:BoundField>   
              
                
            
                
        </Columns>
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#999999" />
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    </asp:GridView>

migrating the entire database from sql server to mysql

dude_123 — Wed, 18 Nov 2009 12:04:35 GMT

Hi all,

I want to move the database of my asp.net application from one server(sql server 2005) to another(mysql).The new server use mysql and it is a linux server.My first doubt is whether it is even possible to migrate the db without any problems........can i face any compatibility issues or any other problems.

thanks in advance.

MySQL Net Connector 5.1.7

wallace740 — Thu, 12 Nov 2009 19:07:14 GMT

I made my website using MySQL Connector 6.1.2 but when it comes to publishing the website.
The hosting company told me that they only support up to MySQL Connector 5.1.7.

I uninstalled 6.1.2 and installed 5.1.7 but now Visual Studio doesnt see the MySQL Database.
I uninstalled 5.1.7 and reinstalled 6.1.2 and it works back again.

Somethings wrong with the 5.1.7 version of MySQL Connector.
I Add Reference(MySQL.dll) to my project
I checked the machine config and it seems ok,there are assemblies regarding to MySQL so it is registered but it is not integrated into Visual Studio :(

Any idea about this issue?

Writing trigger is driving me crazy

bbcompent1 — Fri, 13 Nov 2009 16:24:30 GMT

Ok, I'm trying to create a trigger for my database and from all the various internet sources, my syntax should be fine but MySQL is not agreeing. The trigger I'm writing is (line numbers just for ease of reading):

1 create trigger tr_bi_ewise_slice before insert on
2 ewise_slice for each row
3
4 BEGIN
5 set new.slice_timestamp := dateAdd(now(),INTERVAL -5 MINUTE)
6 END

It gives me this:

#1064 - 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 ') END' at line 5

I really dont see what it is that I'm doing wrong, can anyone tell me what is wrong with my syntax? According to http://www.databasejournal.com/features/mysql/article.php/2190421/MySQL-date-and-time-functions-Part-2.htm the format of my query should be fine.

Godaddy and mysql with asp.net

dreamitaspdotnet — Mon, 16 Nov 2009 15:14:46 GMT

Hi friends,

I created a site with asp.net and mysql , and ofcourse it works great in localhost. I tried to host with godaddy...wow it is not working. The reason is godaddy hosting security is set to medium trust level and the mysql.data.dll assembly does not allow the partially trusted callers to get connected.

And i found the work around solution in the following post

http://forums.asp.net/t/999456.aspx

and this is what recommended in the godaddy support site aswell

So i recompiled the dll file and tried in my local system, it is working fine...When i uploaded the recompiled dll to the godaddy hosting and tried to run

it is still showing the following error

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: System.Security.Permissions.SecurityPermission

and i complained to them again, they told me to develop the site to run in medium trust level or buy a virtual server.

any help to overccome this is verymuch appreciated.

thanks in advance

using LIMIT in sub query? (in code behind)

Boddam — Mon, 16 Nov 2009 09:42:36 GMT

Hi,

I would like to include LIMIT in a subquery and although it is not fully supported yet by MySQL there is a workaround posted. It's working fine when I try it in MySQL Query Browser but how can I get it to work using a MySqlDataAdapter in code behind? I get the error @i is not declared. I assume the problem is executing two seperate queries but I don't know.

If anyone has an idea please let me know, thanks.

There is a workaround for the use of LIMIT in a subquery, just use a variable (seperate query, execute this one first):

SET @i = 0;

And then the select-query with the subquery including the LIMIT:
SELECT
*
FROM
my_table
WHERE
id_my_other_table IN(
SELECT id FROM my_other_table
WHERE
( @i := ( @i +1 ) ) <= 10
);

In this case there's a limit of 10 results in the subquery.

Foreign key constraint problem

GoranPersson — Mon, 09 Nov 2009 16:31:15 GMT

This question should probably be in an mysql forum, but since this is the place where I seek my wizdom I will put it here.

The problem is that I can't get rows to be deleted through a foreign key constraint.

I have a table "Team" and another one "Group". Team contains GroupId and I do like this

ALTER TABLE `Team`
    ADD CONSTRAINT `fk_Team_Group` FOREIGN KEY (`GroupId`) REFERENCES `Group`(`Id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE

But later when I go Delete from Group the rows in Team are still there.

I'm I doing something wrong? Probably. But what?

What is the difference between "= ANY " & "IN"

Boddam — Mon, 16 Nov 2009 00:59:43 GMT

I have used IN quite often but now I came across =ANY and im wondering if there is any difference between them two 
and if either one shall be preferred? I tried a search in Google but it's darn tough with keywords =,IN,ANY 


SELECT * FROM t1 WHERE column1 IN (SELECT column1 FROM t2)

SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2)

Query problem

Boddam — Fri, 13 Nov 2009 16:59:37 GMT

Hi,

I have a query like the one below which is working fine. But now I would like to add some specific rows from table1. How do I do that in a proper way?

My original query:
SELECT a.* FROM table1 a INNER JOIN table2 b ON a.itemID=b.itemID

In addition I would now also like to include these rows into the selection
SELECT * FROM table1 WHERE somecolumn='111'

update

archanaprasad — Sat, 14 Nov 2009 07:16:24 GMT

hi all,

when we enter id in textbox the second page will display the user details of that id

webapplication my database is mysql

JOIN same Table, different Table, different Databases??

Boddam — Fri, 13 Nov 2009 09:39:25 GMT

I have a table where two of the columns are named "ItemA" and "ItemB". Both columns consist of numeric itemnumbers such as 1,22,55,195 etc. I often cobine these coumns with some form of JOIN or UNION which I have a feeling is very ineffective from a performance point of view, joining columns from the same table. Anyhow, it makes it hard to work with so I want to take ItemB out of that table.

So, my questions is: Is it better to put ItemB in a different table and do the JOIN/UNION between the tables? Or is it even faster to put ItemA and ItemB in different tables?

Both ItemA and ItemB will be quite large.

Newbie confused MySQL and SQL

Jasonstores — Thu, 12 Nov 2009 10:57:30 GMT

Im a little confused, do i need to run mysql and sql?

I seem to have database problems and i dont remember seeing mySQL and now i have it.

My connection string is set for the SQL Database, yet in plesk under databases i have mysql data base that has (This resource is used by the installed site application), i cant seem to delete it or change back to the original database.

Here is my stack trace.

Stack Trace:

[SqlException (0x80131904): SELECT permission denied on object 'BannerCodes', database 'friendsdatingfriends', schema 'dbo'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader() +12
   System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) +975
   System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) +113
   System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +344
   System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +35
   System.Linq.Buffer`1..ctor(IEnumerable`1 source) +247
   System.Linq.Enumerable.ToArray(IEnumerable`1 source) +81
   AspNetDating.Classes.BannerCode.Fetch(Nullable`1 id, Nullable`1 position, Nullable`1 getDefault, eSortColumn sortColumn) in C:\Projects\AspNetDating65AjaxChat\Classes\BannerCodes.cs:191
   AspNetDating.Classes.BannerCode.Fetch(ePosition position, eSortColumn sortColumn) in C:\Projects\AspNetDating65AjaxChat\Classes\BannerCodes.cs:147
   AspNetDating.Components.BannerView.OnPreRender(EventArgs e) in C:\Projects\AspNetDating65AjaxChat\Components\BannerView.cs:78
   System.Web.UI.Control.PreRenderRecursiveInternal() +80
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

ASP.NET Membership security MySQL vs SQL Server

bbcompent1 — Wed, 11 Nov 2009 17:07:14 GMT

This is kind of convoluted but I'm going to try to explain this as best I can.

I am using ASP.NET role/membership to secure my web application. The login information is held in a SQL Server. The customer information is held in a MySQL Server. The quirky thing I'm dealing with is how to get the two database systems to associate the newly created user (SQL Server) with the customer profile (MySQL Server).

One idea I had was to use MySQL for the role/membership information but that did not go down so well. I simply could not get the application wizard to recognize the MySQL database.

If anyone here knows how to get a remote MySQL Database to be the membership and role data source, I'm certainly interested.

Connecting to mysql localhost

new coder — Thu, 08 Oct 2009 01:39:49 GMT

I just used part 1 and part 2 of this tutorial and I did all the installation/configuration, but when I try to run my page, I get the following error:

I cannot find any resolution, anyone? thanks.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

<body>
    <form id="form1" runat="server">
    <div>
        <table>
            <tr>
                <td>Type of Property</td>
                <td><asp:DropDownList runat="server" ID="DDLPropertyType" DataSourceID="ODSPropertyType"></asp:DropDownList></td>
            </tr>
        </table>
        <asp:ObjectDataSource runat="server" ID="ODSPropertyType" TypeName="DataAccess.DataReader" SelectMethod="GetPropertyTypes">
        </asp:ObjectDataSource>
    </div>
    </form>
</body>

namespace DataAccess
{
public class DataReader
{

public static DataSet GetPropertyTypes()
        {
            string connectionString = "server=localhost; user id=Developer; password=mypassword; database=mydatabase; pooling=false;";
            SqlConnection sqlConnection = new SqlConnection(connectionString);
            string queryString = "select * From propertytypes order by propertytypedescription";
            SqlDataAdapter dataAdapter = new SqlDataAdapter(queryString, sqlConnection);
            DataSet dsPropertyTypes = new DataSet();
            dataAdapter.Fill(dsPropertyTypes);
            return dsPropertyTypes;
        }

}