i am trasfering the data from internet to database tables or entering information in to data base mean while i lost the connection then, the process gets stop for some time.if connection gets after some,is it possible to resume the data trasfer?
View 3 RepliesSQL Server Express 2005 MS Visual Studio 2005 Using ASP.NET with VB code behind. Requirements: Click a button on an ASPX page to disconnect temporarily all DB connections when not in use to allow a script to backup/copy the database to a safe backup location. When a user access the db afterwords, the DB connections will be re-established.
If this is imposible, recommend an alternative. Note: I am working with what I have been given and authorized to use.
I 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.
i have gridview in my page.
i want all data that show in gridview be on center of row i wrote this code but it didn't worked.Â
<ItemStyle HorizontalAlign="center" VerticalAlign="Middle" ></ItemStyle>
what can i do?
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 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 a datalist control,inside which I have an Image button and a label.They are getting populated from db.Labels are corresponding to the Images.So,Image1 is of Tajmahal,the text of the label will be "Tajmahal" etc.
Now there are some items,for which no image is available and the default image which is coming for such items,is: "NoDataFound.gif".
I need to show the 'Name' of the corresponding item in the middle [horizontally and vertically] of those type of images["NoDataFound.gif"].
[Code]....
In my gridview I got 7 colunms, the first is a checkbox colunm. When the user clicks the "From" colunms data IE "who the message is from" two need to happen. One the application navigates to the next URL and the user can read his/her mail, two and here my issue how do I transfer the data from each colunm to the next page...I was thinking session some how?
View 1 RepliesI have a form in which data data is entered. Thsi date is filled to a gridview. I want to transfer all the datas in gridview to a table in the database .Please help
View 9 RepliesI built a data list list in the follow. It seems that href is not asp language. How can I transfer it to asp language?
<ItemTemplate>
<a
href="~/Team.aspx?Id=<%#Eval("TeamId")%>">
<%#Eval("TeamName") %>
</a>
</ItemTemplate>
From.default.aspx
DataTable Basket_DataTable = null;
protected void Page_Load(object sender, EventArgs e)
{
//create an empty DataTable and Add some columns to it
Basket_DataTable = new DataTable();
[code]....
I am storing data in session and on to.aspx ... I am displaying it. But the only last selected one is displaying ...
how to transfer the grid view from one page to another.
i insert data in one page , i need grid view should display in next page.
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 RepliesFor 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 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 RepliesThis is the class file im using to export the datagrid to excel sheet. Problem is i cant able to transfer the image from gridview to excel sheet using this code. What are the modifications i can do for the below code to export the image.
public class ExcelReport
{
# region Export to excel
/// <summary>
/// Function for Export html report to Excel sheet
/// </summary>
/// <param name="fileName">File name</param>
/// <param name="gv">Gridview</param>
///
public void ExportToExcel(string fileName, GridView gv)
{
try
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
Table table = new Table();
if (gv.HeaderRow != null)
{
//gv.HeaderRow.CssClass = "GridviewStyle";
// gv.HeaderRow.Font.Bold = true;
PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}......................................
I 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 RepliesWhen image button(+) is pressed the selected row of gridview1 is shifted to 2nd gridview.And in the 2nd gridview there is also a imagebutton(delete),when the delete button is pressed that row will move to 1st gridview.
View 1 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 RepliesHow 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]....
how do I transfer my data to another page.
Have 3 textbox whose value must be transferred..
I have a gridview with these columns: id,name,price,quantity,total. Also i have a button and checkbox in every row of gridview. When i check some rows i would like these rows with the button to transfer in another gridview.How can i do that?
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource3">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" />
<asp:HiddenField ID="hdValue" runat="server" Value='<%#Eval("ID") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"
ReadOnly="True" SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" ReadOnly="True"
SortExpression="name" />
<asp:BoundField DataField="price" DataFormatString="{0:c}" HeaderText="price"
ReadOnly="True" SortExpression="price" />
<asp:BoundField DataField="quantity" HeaderText="quantity"
SortExpression="quantity" />
<asp:BoundField DataField="total" DataFormatString="{0:c}" HeaderText="total"
ReadOnly="True" SortExpression="total" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Land]"></asp:SqlDataSource>
</div>
<div>
<asp:Button ID="Button1" runat="server" Text="Button" />
</div>
how to transfer data from one page gridview to another page gridview
in my gridview control 1st column is checkbox,2nd column is product name, 3rd column is price, 4th column is quantity
5th column is total. in this gridview iam using paging, when user selects any no of checkbox that selected row data i have to take it to another page
but iam facing problem when iam selecting some records from 1st page and then iam visiting next page then previous page records iam missing.