I want to transfer temporary table from one server to another linked server. I want to transfer it like how Bulk insert does. Right now I'm transferring row by row. It should do bulk transfer.
View 6 Replies
I am working on one project which is totally related to Trading.i am working on one module of invoice generation .here i used temporary table .all the product which is selected by the customer , first those all are stored in " data table" and when i am going to press submit button all product or data stored in data table directly stored in Database... i don't know how to clear that temporary table on button click....
View 3 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
How to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
i am trying to create a temporary table as like an existing table.
create table #tmp AS ( select Table1.* from Table1 where Table1.column name in (select Table2.column name from Table2 where conditions) )
But it is showing Error...
i need to execute stored procedure on linked server (create procedure on linked server). i had try with this:
[Code]....
SQL code is looking like this
[Code]....
UDBV68 is linked server... Now, when i execute procedure from asp.net i got error 'Incorrect syntax near 'GO'.', but sql server doesn't report error...
Dbcall has value = "EXECUTE ('Create Procedure SelectOne as Select * From FixitOnline.Os_node ',952) AT UDBV54; GO"
For a school assignment I need to transfer excisting data from an acces database, to a new sql database.
I'm not allowed to use datasources, I may only use ADO.net objects.(data adapter, command, connection, ...)
Is it a good idea to start transfering the data in the 'while' loop? Could anyone show me how I can connect to my SQLDB, and transfer the selected table?
[Code]....
I want to create a temporary table where the columns of that temporary table needs to be dynamic (those columns needs to come from the rows of another table)
View 6 RepliesCan i make a bulk insert into the temporary table by calling a stored procedure from the front end.
Am using BulkCopy command to write data to server
bulkcopy.destinationtablename="#TempTableName";(here i want to give the tempoary tablename which is created in the database)
bulkcopy.Writetoserver(datatable dt);
How to do this?
(OR)
Is there anyway to create a temporary table from C# and set the destinationtable as #TemPTableName and then write to server.
how to transfer my data from devlopment server to production server ,i have already records exist in my database if i go for script then how can i transfor record in script i can transfor only table ,procedure and views.I am using SqlServer 2005.
View 2 RepliesI have a requirement to fill the pdf file.
We are using Sql server and i want to transfer data from SQL server to pdf file.
how to move a database table from one server to another server database.This is performed
when I click a button in .aspx page like import the table goes and adds to the another server database in web application.
how can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 RepliesI have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 RepliesI have a class which implements IHttpHandler that is designed to handle image resize requests. It handles Urls like so [URL] Currently the handler looks for myimg.jpg on disk, cuts a 100x100 thumbnail (if it isn't already present) and redirects the client to the thumbnail like so Response.RedirectPermanent("/some/virtualPath/to/thumbnail.jpg");
This has been working great, but I would like to avoid forcing the client to issue a second HTTP request. Is it safe to do the following? Server.Transfer("/some/virtualPath/to/thumbnail.jpg") All the MSDN documentation talks about using Server.Transfer() to redirect to an aspx page, so I'm not sure if this is the right thing to do or not.
I have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesI have a stored procedure in my database that sorts a dataset by distance from the specific address input by the user. The distance is created among each individual users query and the sorting of distance occurs within my stored procedure, the distance is not returned in the output. Is there a way I can create a temporary column that returns the distance so that I can give the user an option to sort by distance?
View 9 RepliesI don't know why I did have the following problem with this. USE [myschema]; select acc,acc_name from ORA_sys2..oraschema.acc_table; Msg 7314, Level 16, State 1, Line 3 The OLE DB provider "OraOLEDB.Oracle" for linked server "ORA_sys2" does not contain the table ""oraschema"."acc_table"". The table either does not exist or the current user does not have permissions on that table. But within the SP, I did make use of the following way without any problem! from ORA_sys2..oraschema.tab2
View 2 RepliesI am insert and update the data in Excel sheet.while iam deleting the data it gives the Error like Deleting data in a linked table is not supported by this ISAM.
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Fileloc + ";Extended Properties=Excel 12.0;Persist Security Info=False";
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
String cquery1 = "Delete from [data1$] where id=" + Txtid.text;
OleDbCommand cmd = new OleDbCommand(cquery1, excelConnection);
excelConnection.Open();
cmd.ExecuteNonQuery();
excelConnection.Close();
I have come from MS Access and am working through a couple of textbooks on ASP.NET 4. I am using the Gridview control connected to an SQL data source control.
As an exercise I am converting my simpliest MS Access page which is simple a form to request a new stock item in our engineering stores. I have a normalised table called [stock_requests] and part of this is a field calle [failure_mode]. This field is an integer and there is another table listing the possible values for this field.
This other table is called [failure_modes] and has two field:
[id] < the primary key
[mode] < the text to be displayed
In my main table [stock_requests] in the field [failure_mode] I store the [id] from the [failure_modes] table for the applicable record in the [failure_modes] table. So for example if someone wanted to select "Catastrophic" as the failure mode the [stock_requests].[failure_mode] field would be 1; if the user selected "Gradual" as the failure mode the [stock_requests].[failure_mode] field would be 2 etc.
Now, the gridview wants to display "1" or "2" but I want to display "gradual" or "catastrophic" without using views and all the headaches that brings. I have managed to sort out editting by using a templated field where I have a drop down list in this cell and I databind to a second SQL data source (imaginatively called SqlDataSource2).
what is the best method for displaying the text 'Catastophic' or 'Gradual' etc. when in normal mode (view mode)? Is it another templated field and what is the basic approach I should use? I reckon I should be able to work it out once someone points me in the right direction.
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 RepliesI'm creating a small forum for my CMS and I'm using subsonic 2.2 as my DAL.
I'm loading my theads like this:
DAL.ForumThread item = DAL.ForumThread.FetchByID(id);
In my database my ForumPosts table looks like this:
ForumPostID | ThreadID | Description | UserID | CreatedOn| etc
So now when I have my DAL.ForumThread item I can load the connected post collection by using:
item.ForumPosts();
This all works great, but the problem is that I'm using serverside paging and want to add some additional select parameters too like showing only active records.
Is this even possible when using SubSonic 2.2 ? The workaround I have now is just creating a new SubSonic.Query and select the posts by threadid and there I can set pageindex and pagesize without problems but I think this can be done easier?
I also would like to know if it makes any difference performance wise by just using item.ForumPosts() or starting a new query, I think the forumposts are already in the ForumThreads collection and don't require a new database call right?
Does anyone have a simple / working example of how to add paging to a Datalist control when the data for the Datalist control comes from an SQL database?
View 4 RepliesI want to transfer data from an acces database to a sqldatabase. This is my code:
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class _Default : System.Web.UI.Page
{
#region page load
protected void Page_Load(object sender, EventArgs e)
{
}
#endregion
protected void click_Transfer(object sender, EventArgs e)
{
OleDbConnection conn1 = null;
OleDbDataAdapter da1 = null;
DataSet ds1 = null;
SqlConnection conn2 = null;
SqlDataAdapter da2 = null;
DataSet ds2 = null;
// 1 Opzetten dataAdapter en dataset
try
{
// Ophalen connectiestring en opzetten v/d connectie
string connString1 = ConfigurationManager.ConnectionStrings["PrinterConnectionString"].ToString();
conn1 = new OleDbConnection(connString1);
string connString2 = ConfigurationManager.ConnectionStrings["PrinterConnectionString2"].ToString();
conn2 = new SqlConnection(connString2);
// Aanmaken van DataAdapters
da1 = new OleDbDataAdapter();
da2 = new SqlDataAdapter();
// Opzetten SelectieCommand
string sql1 = "SELECT * FROM tblPrinter";
OleDbCommand cmd1 = new OleDbCommand(sql1, conn1);
SqlCommand cmd2 = new SqlCommand(sql1, conn2);
da1.SelectCommand = cmd1;
da2.SelectCommand = cmd2;
string sql2 = @"INSERT INTO tblPrinter(PRINTER_ID, tblSoortApparaat, MERK, MODEL, LOKAAL_ID )" +
@"VALUES (@id, @soort, @merk, @model, @lokaal)";
cmd2 = new SqlCommand(sql2, conn2);
// InsertCommand dataAdapter
cmd2.Parameters.Add("@id", SqlDbType.Int, 0, "PRINTER_ID");
cmd2.Parameters.Add("@soort", SqlDbType.NVarChar, 100, "tblSoortApparaat");
cmd2.Parameters.Add("@merk", SqlDbType.NVarChar, 100, "MERK");
cmd2.Parameters.Add("@model", SqlDbType.NVarChar, 100, "MODEL");
cmd2.Parameters.Add("@lokaal", SqlDbType.Int, 0, "LOKAAL_ID");
da2.InsertCommand = cmd2;
ds1 = new DataSet();
da1.Fill(ds1, "PRINTERS");
ds2 = new DataSet();
da2.Fill(ds2, "PRINTERS2");
// Stap 2: Start bewerking!!
DataTable table1 = ds1.Tables["PRINTERS"];
DataTable table2 = ds2.Tables["PRINTERS2"];
DataRow newrow = null;
for (int i = 0; i < table1.Rows.Count; i++)
{
newrow = table2.NewRow();
newrow["PRINTER_ID"] = i + 1;
newrow["tblSoortApparaat"] = table1.Columns[1].;
newrow["MERK"] = table1.Columns[2].DefaultValue;
newrow["MODEL"] = table1.Columns[3].DefaultValue;
newrow["LOKAAL_ID"] = table1.Columns[4].DefaultValue;
table2.Rows.Add(newrow);
}
da2.Update(ds2, "PRINTERS2");
lblMessage.Text = table1.Rows.Count.ToString() + " rijen zijn toegevoegd";
// bindgrid();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
}
Here is my problem newrow["tblSoortApparaat"] = table1.Columns[1].; When i do that al the rows in my sql database are filt up with the columname. But i want the specik data. For example sql database:
1 tblSoortApparaat
2 tblSoortApparaat
3 tblSoortApparaat
But what i want is
1 PRINTER
2 PC
3 PRINTER
I have a table named Transactions in which there are Four Coulmns
ID, TransactionsID, LablelName , Data
In Current scenario all the Data is containing in the above table for example
ID, TransactionsID, LablelName , Data
1, 1, CustomerID, 1
2, 1, CustomerName, John Smith
and so on ...
Columns are only four and data is increasing in Row Format.
Clear me advantages and disadvantages
is this datastructure entry or logic is correct or what are the drawbacks of using this technique?
