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]....
May 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 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 RepliesI want to read the customers first name from the customer table below. Then right pad it with
blanks so that it will always have a length of 50 characters. This is not working for me and I need
help. Can someone help me? Here I create a temp table, populate it with the padded data. However
the padding does not work?
CREATE TABLE #Rab (YaName char(60))
select v.CustNum INTO Rab from (
select LEFT( FirstName + SPACE(50),50) As CustNum from Customer
) AS v
Customer table :
John Smith 22
Jimmy Gotro 33
Mimi Fox 31
I want to Update Column of a Table where ColumnName will be DropDown.SelectedValue. Example: A set of RECORDS will be displayed from a Customer Table where CUstNo ='1234' and City= 'Chicago' and Grade ='B' Once displayed I want to Update the grade to 'A' of all those customers from the above criteria. In My case I have like 100 Columns, so in where Clause Column Names will be selected from a DropDown. In My Query, Update Customer SET ColumnName= 'some value' where ColumnName ='ActualValue' So how can I pass the ColumnName which is Dropdown Selected Value. I believe I can't give as Update Customer SET DropDown.SelectedValue = 'some value' where DropDown.SelectedValue ='ActualValue' how can I resolve this ?...
View 9 Repliesi am creating a print view using checkboxes that a customer uses to select which items they wish to print. I am having difficulty transfering the selected gridview items to another page. I was using crosspage post.
View 2 RepliesI want to transfer gridview record to another gridview. Actually I have placed a checkbox column in 1st gridview. Now what I want that when i select the checkbox of any row the related row transfer to 2nd gridview and when I deselect it that row it returns to its previous position in 1st gridview. All these things I want to do using Javascript.
View 1 Repliesi 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 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've got a SqlDataSource that is created in the markup and would like to transfer the data to a dataset in code behind. How do i do this?
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 get Datalist Checkbox Select Item To The Another Datalist on click CheckBox
Code Like
<form id="form1" runat="server">
<div>
<h2 style="background-color: #CCC; font-size: 16px; font-family: Arial, Helvetica, sans-serif; font-weight: 400;" class="heading">Brand</h2>
<asp:DataList ID="DataList5" runat="server" Style="font-weight: 700; color: #CC33FF; background-color: #66FFCC;" Height="100px" Width="122px">
<ItemTemplate>
[code]....
[URL] .... In that tutorial temporary DataTable used to maintain the list selected rows or records and then use the DataTable to bind the secondary GridView. What I'd like to do is;
I'm using the IfUserIsInRole function and when I get the users Identity and name I'm prepopulating the gvSelected GridView with data (only people associated with that user) on page load. When I try to add none prepopulated people from the gvAll GridView to the gvSelected GridView all the origional prepopulated rows from the gvselected GridView are over written.
How can I prevent this from happening?
I have a situation where images are already uploaded in a folder. Now I dont need to upload image from client PC just select from list of images retrieved through File.IO and transfer selected one to database. Any ready script available?? Similary I need to retrieve stored image from database and display in image control..
View 3 RepliesI have a table which contains 2 lables,1 checkbox and i1 image.how to connect this to a list view.how to write Eval code in the Text property of list view.
View 3 RepliesI need to provide a way for the user to specify a path to a file on his machine on my intranet web application, and the ASP:FileUpload control provides a nice dialog to do that, however it also transfers the contents of the file over. Since I only need the file path and not the contents, is there another way to achieve this?
View 2 RepliesoledbCon.ConnectionString = "Provider=MySqlProv; Data Source=localhost; Initial Catalog = AnymoreComputers; User id=WeakUser2;Password=1234";
my site is working and running wrote in c# and mssql 2005,
now i want to make it run with mysql.....i converted all my data base...and created the same users (same names)
anc copied all to my sql .
the question is how do i connect to mysql wit c# ......
my regular connection for mssql :
oledbCon.ConnectionString = "Provider = SQLOLEDB.1; DATA Source = (local); Initial Catalog = test1; Integrated Security = SSPI; User ID=WeakUser2;Password=1234";
the connection to mysql :
oledbCon.ConnectionString = "Provider=MySqlProv; Data Source=localhost; Initial Catalog = test1; User id=WeakUser2;Password=1234";
this connection doesnt works ... where is my mistake ? what hsould i do ... ?
and this is the error ig get when i run my solution :"The ConnectionString property has not been initialized."
i am using OleDbDataAdapter and dataSet ....
There is any another way to connect SQL Server database instate of Server Explorer i ASP.Net MVC .If yes tell me How?
View 3 Repliesi would like to ask about the connect to db using sqldataadepter code as below:
public static DataTable GetTest()
{
DataTable dt = new DataTable();
[code]...
we have local net in our company.(we dont have win server.)
now i want to know how i can connect to the sqlServer in pc1 from pc2?
I'm new here and I'm in dire need of help. Been trying to solve a problem for hours now.Here's what I wanted to do: I added a table 'tblProductCat' in the webform and I intend to populate the table with VB codes as shown below
[Code]....
What am I doing wrong here? I really can't figure this out. There was a time when, instead of that exception handling message appearing, a yellow box that states something between the lines of 'offline' and 'check your root folder for *something*' or something like that.
Is there a way to connect to a db that is not on your network!?!? How would I do that?
Using VS 2008.
I'm running SQL Express 2005 on an SBS 2003 Standard Server and I keep getting this error back.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: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol)
I've uploaded my project to this same server, and I've so far checked that TCP/IP has been enabled for this instance, I've checked the IPs are relevant, I've checked that the connection string is correct, and I've even set a dynamic port number as I've noticed that SBS runs 2005 databases for Sharepoint and Monitoring.
Interestingly enough, I can connect to this instance via Visual Studio on my remote machine, and SSMSE and also via SSMSE on the server as well?The connection string i'm running with is:
Data Source=localhostVDSSQL;Initial Catalog=myDB;Persist Security Info=True;User ID=SA;Password=***
i have been trying to connect to SQLserver from ASP.net web developer in an n-tier architecture.But it shows this error in conncetion
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)
i want to know how to connect to multiple databases in sql from our asp.net code??
View 4 Replies