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..
View 5 RepliesActually i need to transfer data from one table to another table in mysql with codition of Time.for example i need to transfer data at 10.00am when user login at 10.00am it must be insert into another data table.. if anybody know time control
View 2 RepliesI try to work with MYSql (because it's free) and I saw that the colums are different then when they are exployed in MS SQL?
Why is this? The most strange differents is that in MySQL there is no applicationId in the membership table.
This differents in tables cost me more time to do a export and import from MS SQL to MySQL.
I developed a web site more then a year ago with .net2.0/c#/mssql 2005. it works fine but i was asked to replace mssql with mysql.
I wrote a class to complete data access works (unfortunately, I didnt use nhibernate or other data access tools :((
I edited the class to use System.Data.Odbc objects rather than System.Data.SqlClient.
It works fine in selecting data but not manipulating data. when i try to insert new data it adds null data for all fields in the table.
in debug mode, i noticed that it might be caused by OdbcParameter but not sure.
i am very new to the programming and also asp.net. i have an assignment to create a table on webpage the information is coming from mysql database.
View 2 Replieshow 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.
View 3 RepliesI 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.
View 1 RepliesI'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?
View 1 RepliesMay you tell me how can I transfer data from a table to another table, the condition of non-repetition rows
as a procedure in database MS QSL server 2005 ,Works in the first day of the month I use the first table in the prodation environment it is contain the employee data and the second to update first table only
I have Revision column in Quote table with time stamp (MySql table) now i am viewing the entire date and time my end user want to view only Date he doesnot want to see time how can i pull only date.i am displaying revision column in two ways one in grid view and another one in field value
Query in my Grid view
Dim query As String = "SELECT QuoteNumber,Revision,Vendor,PartNumber,status,Customer,Requestor from quotes"
On select check box in grid view, filed values will be loaded with data.
field value
txtRev.Text = dt.Rows(indx)("Revision").ToString()
I have been trying to create a sql statement that uses a subquery to join 2 oracle tables to create a strongly typed table adapter. For example:
Select productName, (select categoryName from categories where categories.category_id = products.category_id) as Category from Products
The ASP .Net tutorial I am working through recommends using subqueries instead of joins for the insert, update and delete commands to be automatically generated by Visual Studio 2010. When I click Finish in the table adapter wizard I get the following error (I am using MySQL version 5.1 and the MySQL Data Connector 6.3.5)
Generated SELECT statement.
Error in SELECT clause: expression near 'SELECT'.
Error in SELECT clause: expression near 'FROM'.
Missing FROM clause.
Error in SELECT clause: expression near','.
Unable to parse query text.
I am building a little app to upload a picture and various downloads for different file types for the photos, but I also need be able to select the catergory they will go into. So I have two tables one that stores the catergory names and one that holds the paths to the photos and downloads the tables are related through the catergoryID.
What I need is those catergories to show up in the photo's and downloads table so that when I go to upload the photos I will be able to select the categories.
I have also built the DataSet and the Business Logic.
I am working in asp.net and in that i am using grid view and now i want to convert grid view data which is dynamic to the html table so i can send an email.
View 1 RepliesI 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.
Is there a was to automatically write a tables contents to a .txt file? For example, a table 'deals' has the columns [id], [col1] and [col2]. Another table called 'customs' has the columns [id], [info] and [details]. both [ids] relate to one another. In 'deals', the col1 and col2 data will change, but when the [col1] = [col2] id like the corresponding [id]'s on the other table to be identified and [info] and [details] data be written to a .txt file.
View 2 RepliesI have used ASD.NET code using SQL Database for Transaction operation successfully. By changing the Database Code to interface with MYSQL an Error occurs. If I remove the Transaction Code from within the the application, it works OK by displaying the MYSQL data (Read Only) in the layout of the application. I am using Mysql Essential-4.1.22-win32 and MYSQL Connector ODBC-3.51.2. My objective is to EDIT the MYSQL Data.
View 8 Repliesi have adatbase in the database i have atble when i drag it into the page i get agridview auotomaticle and in the configuration when i choce to edit culomn-->commandfield i have edit select delet but i want to add to the table aoutomaticle who could i insert to the table aoutomaticle
View 2 Replies1)table student
studentno varchar(50)
hobby1 varchar(40);
hobby2 varchar(40);
hobby3 varchar(40);
2)if record in data database such that
hobby1 hobby2 hobby3 in this maximum is one must be chose
like
here studentno hobby1 hobby2 hobby3
1 cricket null null
2 null hockey null
3 null null tennis
if i want to write function in mysql if i pass the studentno
i want to get the hobby of respective student
like select functionname(1)
your hobby is cricket
like select functionname(2)
your hobby is hockey
ike select functionname(3)
your hobby is tennis
I want to extract data from table into a view. MEans i have datatime field with value '12/31/2010 12:00:00 PM' in a table .
I want to change the field format in view to Date like '12/31/2010'.
Iam using oracle 10g.
I need to pass many records with number of fields(i.e 5rows and 5 columns) in either array or table form to oracle for processing. Is it possible to pass array/table from asp.net pages? If no, any solutions for this? I have been thinking of passing it as string concatenated with delimiter and split it. Seems like it is not appropriate as i have to pass 5 strings(5rows)
View 2 Repliesi have one task. i store the table records in tab delimiter then i want read that txt file data's line by line via asp.net application codebehind file after that i want insert into another table
[code]...
i am developing an appilication using asp.net 3.5 with c#.net and SqlServer 2005 as backend databse.
in my application i have to import the data from excel file to database. the fields in excel file and fields in databse table are same. i just want to import all data to that database table.
I need to fetch the data from a table with Alias name in oracle.
example: select f1 'Field Name1',f2 'Field Name2' from sometablename;
I have a multi select listbox (list from database). I would like to transfer the items that have been selected in to a blank table and be inserted the list in the database (eq. 3 new item will be added in 1 database row only with 3 columns). using c# .net
View 2 Repliesi was just using mysql i installed mysql and mysql net connector. its installed successfully but unable tp add to references.
View 3 Replies