Trying To Configure ListView - SqlDatasource For A MySql Table?
Jun 9, 2010
i'm using ASP.NET + a MySql Db. I'm trying to configure a ListView so i've written:
<asp:SqlDataSource ID="dsDatiUtente" runat="server" ConnectionString="Server=12.28.136.29;Database=mydb;Uid=m111d1;Pwd=fake;Pooling=false;"
ProviderName="MySql.Data.MySqlClient"
SelectCommand="SELECT * FROM user WHERE idUser=@IdUser"
/>
At the beginning of my aspx page i've added
<%@ Import Namespace="MySql.Data.MySqlClient" %>
But if i click to the sqldatasource and click "Refresh Schema" i got this error:
"Unable to retrive schema.... Unable to find the requested .Net Framework data provider" For instance, i've installed it , but i've also uninstalled old version, then installed new versions. In my project i simple copy Mysql dll into "bin" folder, then add a reference to that dll. I'm not sure is the corrected way...
I need to have the "refreshed schema" to permit vs.net to build automatically my listview ... if i can't to "auto build" listview, i have to write all code by hand, and it is a too expensive work me :(
I have an ASP.NET 3.5 web form with a DropDownList bound to a table of company names in a database. I also have a data bound GridView which I would like to update with data from the database depending on the company name selected in the DropDownList, so that the SelectCommand for the GridView's SqlDataSource is:
SELECT Registration, Telephone, Profile FROM {CompanyName}_VehicleData
Where {CompanyName} is whatever is selected in the DropDownList. I've used the Command and Parameter Editor to create a ControlParameter pointing to the SelectedValue of the DropDownList, but I don't know how to write the SelectCommand query to concatenate the parameter to '_VehicleData'.
I have a ListView, I've setup to use an ObjectDataSource, I've created my Layout and Item templates, and I'm able pull and view a list of my data no problem. However I want to add delete capabilities to my ListView and my reference material tells me to go into the "Configure ListView..." option under the ListView's smart tag, the only problem is I don't have that option, the only three options in my smart tag are "Choose DataSource", "Configure DataSource..." and "Refresh Schema", what am I doing wrong?
i done one web application in this application i need to transfer the data from one table to another automatically when the time is 10.00PM. i need to write this function sepearte time function not in page load function.the user select any of page the data should be transfer from one to another without page load only using time control function..
I want to display my records in ListView. Per row must have only 3 records. I am using Mysql, The data is connected and retrieved fine. But I unable to configure it's view to "Tiled" Is it possible by using code behind or asp.net source view?
When "Configure ListView..." in the smart tag of ListView is clicked, one can choose one of the 4 styles on the list: Colorful, Professional, etc. I am wondering if there is any way to add one's own style to the list.
I've never used either of these 2 controls before and I'm stuck with no visible rendering of the page (compiles and runs but produces nothing); I have no code behind file with this simple asp.net page and I am using Visual Studio 2008:
I am getting no runtime errors and no errors during the build. The simple query works fine from SQL Query Analyzer (i.e. SQL Server 2000). Any ideas?
EDIT-UPDATE:
Here is what I have in my .ASPX.CS code behind file and I cannot get the debugger to stop on the breakpoint on the .DataBind method:
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace zList { public partial class Index : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { CategoryList.DataBind(); // breakpoint set here but debugger won't stop here } } }
By the way, I fired up SQL Profiler and it appears the SQL select is not even being fired against the server. As I said, the page is empty - just this junk when I scrape it via View Page Source:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1 /DTD/xhtml1-transitional.dtd">
I have MySqlMembershipProvider working with Asp.Net MVC. My question is how can I configure the table prefix... so instead of 'my_aspnet_' prefix on the tables, I want this to be either none or defined by me. My web.config:
I'm trying to update items in my SQL database from a ListView. It works, but all entries in the database update. Not just the one I'm working on. I backed up the database prior to testing, so there's not any issues there.This is how my SqlDataSource UPDATE command is setup:
SQL Code: UPDATE entries SET duration = @duration, checkinDate = @checkinDate, receivedBy = @receivedBy, cosmeticDmgIn = @cosmeticDmgIn, STATUS = N'closed'
I don't have any code setup to update the database, which is probably the issue.When I load the ListView, select edit, type in my edits, and click "Update", all the rows in my database, for that column, are updated with that data.I tried inserting the parameters manually, within the ItemUpdating event, but it never works.
This seems so very simple yet I am very stuck. Following some articles on the web, I came up with an ASP.NET web app page that is all declarative (no code behind) yet when it produces NOTHING I feel so totally stuck about what I've done wrong. Here is the entire little page:
I have a data connection to an existing MySQL database. The database has various tables. I am creating a new table, and want to set the ID field to be the primary key. I can not see a way of doing this inside Visual Studio. I saw one suggestion to right click on my ID field in either the Server Explorer or XSD and select Set As Primary Key (or something like that), but I don't have that option displayed.
I have a requirement that I need to read an excel sheet using asp.net/C# and insert all the records into mysql table.The excel sheet consists of around 2000 rows and 50 columns. Currently,upon reading the excel records ,I am inserting the records one by one using a prepare statement into mysql table.But its taking around 70 secs to do so because of the huge data.
I've also thought of creating a new datarow, assigning values to each cell,adding the resulting datarow to datatable and finally calling dataadapter.update(...).But it seems to be complex because I got around 50 columns and hence I'll have to assign 50 values to the datarow.
how can i create a backup table for my MySql base table.my base table name is FAB when ever user store the data into FAB table same records should be stored into back-up table automatically.how can i acheive this.i am really thank full to you if any one provide me solution.
I have applied audit trail to my webform/table its working fine.I am able to maintain the History(action,action_date) of the MySql database table from ASP.net but I want to save user name i.e action_by too so i will have history of who changed the data and when, how can i acheive to save username in history table.i have login webform in my application. History MySql Table.
How do I implement this session: (UserID is part of the login table)
Session["UserID"]="usrName"; Into this code? using System; using System.Data; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.Odbc; using System.Data.SqlClient; public partial class Default2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { Login1.Authenticate += Login1_Authenticate; } protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { //database connection string OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=gymwebsite; User=x; Password=x; OPTION=3;"); cn.Open(); OdbcCommand cmd = new OdbcCommand("Select * from User where username=? and password=?", cn); //Select the username and password from mysql database in login table cmd.Parameters.Add("@username", OdbcType.VarChar); cmd.Parameters["@username"].Value = this.Login1.UserName; cmd.Parameters.Add("@password", OdbcType.VarChar); cmd.Parameters["@password"].Value = this.Login1.Password; //use asp login control to check username and password cmd.Parameters.Add(new OdbcCommand("@UserID", 'id.int')); OdbcDataReader dr = default(OdbcDataReader); // Initialise a reader to read the rows from the login table. // If row exists, the login is successful dr = cmd.ExecuteReader(); int id = cmd.Parameters["@UserID"].Value; Session["UserID"]="usrName"; if (dr.Read()) { e.Authenticated = true; Response.Redirect("UserProfileWall.aspx"); // Event Authenticate is true forward to user profile } } }
I need to be able to retrieve the correct UserID when some one inputs there username and password upon login and then some how retrieve it on a new page something like this to retireve it but unsure?
I just dont know how to add the first part, the session into my login code so I can some how store the UserID in my session but also retrieve the correct UserID from the submitted data that takes from my mysql login table.
what can I do when my all database table's name into dropdown list & when i select or click the table name from dropdown list display the whole field into the gridview dynamically.
I'd like to have to two tables Countries and states and make it so that any MySql user can access them for the purpose of building databiund drop down lists. What permissions do I need to assign the tables or what's the best way to do this?
I have created a asp.net webpage for viewing daily downloaded newspaper, saved as a pdf file in a selected folder (~/NEWS/{0}) within the web root directory. Also i have a SQL datasource linked, where the news table has two columns viz: date and filename.
I want to create a tiled listview where the date text is visible on the hyperlink. on clicking the hyperlink, the file name is retreived for the corresponding date and the pdf file opens in a fresh page.
I have tried going to the item template in listview and replacing the label control with a hyperlink control, but then not able to successfully proceed ahead.