I expect that the export file will be backup.sql mysqldump --tables -u db_user_name -p db_name >> backup.sql Furthermore, is there any example for that we insert one record with one image file (from the local disk), to the DB table?
View 3 RepliesI need a code which can export the data from XML file to the Excel file.
View 3 RepliesThis is my MYSQL database connection :-
public
static
OdbcConnection Connection =
new
OdbcConnection("Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=jdmcrm; User=root;Password=admin;");
My table name is "customer" and fields liek customerId , companyName , address and date ;
How to do wide search and export the records to excel file ? im quite new in asp.net .
I am trying to export a grdview to an Excel file but I am getting this error and i suspect
the error has something to do with the fact that the code is on a CONTENT page and not web page:
[Code]....
Here is my export code:
[Code]....
So I trying adding this code to avoid the error but this has a problem with a content page:
[Code]....
[Code]....
how can i backup mysql database on button click by giving specific path and restore the database is there any way
View 2 RepliesI could do backup and restore mysql database at my web application run time with VWD 2008 Express. But I test these with IIS, any web browser's progress bar is not increased. My code is the same with this link - URL] . Here, Some facts that makes it not process - I think
My database admin has no password. At run time with VWD, Command Prompt appears and ask to enter password. With IIS, this not appear.I run VWD as a admin. So is there any security with IIS?Finally, we will use this web application with Remote or Virtual Server. Now we could access this application from Remote Server via any web browser. So I test this backup portion but it not work. Here, I give the file path - D:DB - that is valid in my client or current pc but IOException generate message 'Device is not ready.' Drive D is not in Remote Server. So I change Drive E: that is valid in Remote Server. This time, Run time error appears and Description is "An application error occurs on the server...". I think that any client can save backup file under his current pc.
[Code]....
Invalid column name 'is_compressed'.
Invalid column name 'compressed_backup_size'.
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
Processed 264 pages for database 'E:ASP.NET4.0_CalculatorhicalcApp_DataASPNETDB.MDF', file 'ASPNETDB_1847a276f17a4e2cb63c95936431bc26_DAT' on file 1.
Processed 1 pages for database 'E:ASP.NET4.0_CalculatorhicalcApp_DataASPNETDB.MDF', file 'ASPNETDB_TMP_log' on file 1.
BACKUP DATABASE successfully processed 265 pages in 0.404 seconds (5.124 MB/sec).
[Code]....
in sql 2008 , itook a databse back up and i got message like "backup completed sucessfully".i gave the backup name as D123.
now the pblm is when i check that backup file, file name is coming without extension and not possible to restore also.
file name is D123 instead of D123.BAK and filetype is showing 03 instead of BAK
where is the problem?is it possible to restore this back up?
I need to make a backup copy of a file on a remote server. The backup will remain in the same directory on that server. The problem I am having is that the file is large and it appears to be copying it back to the server the code is running on and is taking too much time. Is there a way to make a copy of the file in place without it being sent across the network?
View 4 RepliesI am looking for Backup and Restore . mdf file utility. Is there any opensource application/code available?
View 12 RepliesI need to make a backup file(.bak) of a database(.mdf)
I learned I need to use MS SQL Server management studio Express to do so, but I can't figure it out how.
I don't know how to connect to the database using this program. In the "Connect to Server" dialogue window, I am supposed to choose a server name from the dropdown list, but nothing comes up. What am i doing wrong?
I want send backup statement from my c# code to sql server then sql server return same back up file to my application in varbinary(max). what code is necessary for that?
View 3 Replieswhen I make restore to backup database display this error :
The backup set holds a backup of a database other than the existing 'elib' database. (Microsoft.SqlServer.Smo)
how I can solve this error ?
I have a csv file and I want to be able to open it remove two colums and save it back as a cvs by clicking on one button.
View 3 RepliesHow Can I Import,Export Exel to Sql
View 4 RepliesI am working on a function that when i click a button, the chart control can be exported to an excel file. I have tried searching googles, but no post related can be found.
Does anyone know how to do it?
how can i export mysql data to Excel?
View 3 RepliesI have list of tables in my database.
how to retrieve list of tables including data into databound control and
how to export the tables data to excelsheet individually..
a)Gets the list of tables within the database
b)Gets data
c)Exports the data to excel worksheets (there are 2 methods defined (1) range method (2) cell by cell
d.) Saves the excel sheet
i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server)
i am trying to restore back up database .bak into the new database i just created in sql server 2005i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message"You must select a restore source"
Here's the screen shot: (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)
I am using asp.net oledb to export information to excel file. I encounter problems when the information to export becomes too big, in this case the code I have given below, the excel file generated becomes an empty spreadsheet. If I changed the loop to 1123 for insertion of the rows. The generated excel file is fine, 1125 rows, and 4 columns shown. A test program in windows form is also working fine regardless of how many rows.
Code has been simplified, "information ..." in the sql insertion command represents 1803 characters.
ExcelObjConn = "Provider=Microsoft.Ace.OLEDB.12.0;" & _
"Data Source=" & fileName & ";Extended Properties=Excel 12.0 XML"
ExcelConnection = New System.Data.OleDb.OleDbConnection(ExcelObjConn)
ExcelConnection.Open()
Try
SqlCommand = "CREATE TABLE ABC ([row1] text, [row2] text, [row3] text, [row4] text)"
ExcelCommand = New OleDb.OleDbCommand(SqlCommand, ExcelConnection)
ExcelCommand.ExecuteNonQuery()
ExcelCommand.Dispose()
For i As Integer = 0 To 1124
SqlCommand = "Insert into ABC ([row1], [row2], [row3], [row4]) Values ('information...', 'information ...', 'information ...', 'information ...')"
ExcelCommand = New OleDb.OleDbCommand(SqlCommand, ExcelConnection)
ExcelCommand.ExecuteNonQuery()
ExcelCommand.Dispose()
Next
Catch ex As Exception
Finally
If ExcelConnection IsNot Nothing Then
ExcelConnection.Close()
ExcelConnection.Dispose()
End If
End Try
I couldn't find a solution to my problem as well. What I did eventually was to run the process using another separate windows service. The code works perfectly fine running from a windows form or service program, but not asp.net, not sure why.
In my project i wants to display report and export it in pdf format so that i used rdlc but now my requirement is that there are some labels like name,address for it i wants to give some specific margin from left right(x,y) and i wants to give this margin by config file. "how can we set margin in rdlc from cofig file or run time?"
View 1 Repliesi want to export multiple tables in a dataset to excel workbook with each tables as sheets without using COM Interop or Excel Object.
View 2 Repliesi like to create a web application,in that i need to get the resumes from the user,then i need to publish that resume to the manager in date wise..
View 5 RepliesI have acess db where i perform a select query which communicates to the sql and pulls up the data and export it as a csv file using asp .net 2.0
View 1 RepliesI want export datatable to dbf . the following is my code. the conection dont open
SqlConnection cn = new
SqlConnection("Data
Source=(local);Initial Catalog=test;Integrated Security=True");
SqlDataAdapte da =
new
SqlDataAdapter("select
* from test", cn);
DataSet ds = new
DataSet();
da.Fill(ds, "test");
string directory =
"E://";
OleDbConnection connection =
new
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=E:\TEST.DBF;");
connection.Open();
OleDbCommand command = connection.CreateCommand();
if (System.IO.File.Exists(directory
+ @"TEST.DBF"))
command.CommandText =
"DELETE FROM Test
else
command.CommandText =
"CREATE TABLE Test (ID int, name varchar(50),last_name varchar(50))";
command.ExecuteNonQuery();
command.CommandText =
"SELECT * FROM Test";
OleDbDataAdapter adapter =
new
OleDbDataAdapter(command);
OleDbCommand insertCommand = connection.CreateCommand();
insertCommand.CommandText = "INSERT INTO Test (ID, name,last_name) VALUES (pID,pname,plast_name)";
}
foreach (DataRow
dr in ds.Tables["test"].Rows)
{
int id =
int.Parse(dr["ID"].ToString());
string name = dr["name"].ToString();
string last_name = dr["last_name"].ToString();
insertCommand.Parameters.Add("pID",
OleDbType.Integer, 4, ID);
insertCommand.Parameters.Add("pname",
OleDbType.VarChar, 50, name);
insertCommand.Parameters.Add("plast_name",
OleDbType.VarChar, 50, last_name);
insertCommand.UpdatedRowSource =
UpdateRowSource.None;