Data Controls :: Can Store Data In Excel File In Machine PC Directly

Sep 3, 2013

I have a Stored Procedure

Create procedure selectdata
as
begin
select * from Employee
end

In my front End I Created a Button in default.aspx page 

 <asp:Button id="btnsave" runat="server" Text="Send to Excel" onclick="btnsave_Click"/> <asp:GridView id="gv" runat="server" > </asp:GridView>

In default.aspx.cs 

protected void btnsave_Click(object sender, EventArgs e) {
SqlConnection conn = new SqlConnection();
conn.ConnectionString="User id=aa; password=123; Initial Catalog=abc;Integrated Security=xxxx";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;

[Code].....

Output: It Displays the Data in Grid View   but is it possible to store the Data directly in Excel file in my PC

View 1 Replies


Similar Messages:

DataSource Controls :: Store Images Directly In A Database Or To Just Store The Name Of The File In The Db And Display That File?

Mar 25, 2010

Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...

View 1 Replies

Forms Data Controls :: Directly Reading And Displaying Excel Or CSV File Using Asp Web Controls?

Oct 19, 2010

I can directly use to read and display Excel or CSV files using asp web control(GridView, sqldatasource etc). I do NOT want to upload the file first to an sql database before reading them, I just want to read the files directly. I am using asp.net 2.0 and c#.

View 3 Replies

Web Forms :: How To Upload File Directly From Client Machine

Mar 18, 2013

How to upload the file directly from the client machine. I have one button for mail sending.

If i click the button, the from, to, subject comes using pageload. Like that the default file also could be added as a attachment directly from the client machine.

How to upload the file directly(using file upload control or eithout using file upload control)...

View 1 Replies

Forms Data Controls :: Export Data To Excel And Set Excel File Column Format?

Sep 1, 2010

i have try to export data to excel using gridview.

I have export it successfully but some data is missing which is due to the column format in the exported excel file is not TEXT .

[Code]....

I need to set the exported excel file column format to TEXT but find no solution on this.

View 2 Replies

Data Controls :: Export GridView To Excel And Save Excel File To Folder?

Apr 6, 2014

i use this code to export data into word.

Protected Sub Export(sender As Object, e As EventArgs) Handles btn_printexcel.Click
Response.Clear()
Response.Buffer = True

[Code]....

but the export docs will be downloaded into the user computer.

what should i do so that the exported docs is save into the server?

View 1 Replies

Forms Data Controls :: Exporting Gridview Into Excel Is Not Generating The Result On Excel File?

Apr 1, 2010

when I used a code of exporting gridview into excel this code worked for a new website which is without masterpage.

my code:

public override void VerifyRenderingInServerForm(Control control) { }
protected void BtnGenerateReport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();.....

Now the same code when I copy it in my project having masterpage . there is no compiler error but it is genereating excel file withno data in it but in fact there is data in the grid view at runtime.

View 2 Replies

WCF / ASMX :: Store A Pdf File On Client Machine Using A Web Service?

Feb 23, 2011

I need to store a pdf file on client machine using a web service.

I am unable to find IP address of client machine in web service so that I can insert pdf file in C-drive of client machine.

I am using asp.net 3.5 using c#.

View 2 Replies

Web Forms :: How To Store Data In Client Users Machine Memory

Jul 2, 2013

i Have multiple File upload. press Uploaded button it will store on sever temp folder. those details are in List  on our program.

when i have press the submit then only those listed files fetch form server-temp-Folder and replace in server-secified- folder.

i want to make those list class save into client location for not affted by some of other updates.

how cn i store the custome list in client memory

View 1 Replies

Web Forms :: Read An Excel File From Client Machine In C#.net

Jan 15, 2010

I have developed an application where I need to create a page to read data from Excel File and then update it to the database. The code that I wrote works only when the application runs from my machine. When I deployed the application to the server it gave an error- 'C:PRFileIimport_File.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. here is mu code -

protected void InsertData(object sender, EventArgs e)
{
OleDbConnection oConn = new OleDbConnection
(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\PuertoRicoFile\Puertorico_Iimport_File.xls ; Extended Properties=Excel 8.0 ");
OleDbCommand oCmd = new OleDbCommand("select * from [Puertorico_Data$]", oConn);
oConn.Open(); //Here [Puertorico_Data$] is the name of the sheet in the Excel file where the data is present
OleDbDataReader oleDbReader = oCmd.ExecuteReader();
string AgentIP = "";
string TagName = "";
string Status = "";
string Severity = "";
int EventCount = 0;
string EarliestEvent = "";
string LatestEvent = "";
while (oleDbReader.Read())
{
AgentIP = (string)oleDbReader[0]; // valid(oleDbReader, 0);//Here we are calling the valid method
TagName = (string)oleDbReader[1]; //valid(oleDbReader, 1);
Status = (string)oleDbReader[2]; //valid(oleDbReader, 2);
Severity = (string)oleDbReader[3]; //valid(oleDbReader, 3);
EventCount = Convert.ToInt32(oleDbReader[4]); //oleDbReader[0]; //valid(oleDbReader, 4);
EarliestEvent = (string)oleDbReader[8]; //validate(oleDbReader, 8);
EarliestEvent = EarliestEvent.Substring(0, 19);
LatestEvent = (string)oleDbReader[9]; //validate(oleDbReader, 9);
LatestEvent = EarliestEvent.Substring(0, 19);
InsertDataIntoSql(AgentIP, TagName, Status, Severity, EventCount, EarliestEvent, LatestEvent);
}
SqlConnection mySQLconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["IssNetworkReportingSystemConnString"].ConnectionString);
mySQLconnection.Open();
SqlCommand cmdSql = new SqlCommand("AddMonth_Event_TotalInfo_for_Puertorico", mySQLconnection);
cmdSql.CommandType = CommandType.StoredProcedure;
dbReader = cmdSql.ExecuteReader();
dbReader.Close();
cmdSql = new SqlCommand("AddQtr_Event_TotalInfo_for_Puertorico", mySQLconnection);
cmdSql.CommandType = CommandType.StoredProcedure;
dbReader = cmdSql.ExecuteReader();
dbReader.Close();
oConn.Close();
lblMsg.Text = "Data Imported Sucessfully";
lblMsg.ForeColor = System.Drawing.Color.Green;
}
public void InsertDataIntoSql(string agentIP, string tagName,
string Stat,string severity,int eventCount, string eEvent, string lEvent)
{//inserting data into the Sql Server
SqlConnection mySQLconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["IssNetworkReportingSystemConnString"].ConnectionString);
mySQLconnection.Open();
SqlCommand sqlSelect = new SqlCommand("SELECT SeverityID from Severity where SeverityDesc=@SeverityDesc",mySQLconnection);
sqlSelect.CommandType = CommandType.Text;
sqlSelect.Parameters.Add("@SeverityDesc", SqlDbType.NVarChar).Value = severity;
dbReader = sqlSelect.ExecuteReader();
int severityId = Convert.ToInt32(dbReader.Read());
dbReader.Close();
SqlCommand sqlInsert = new SqlCommand("Insert into IdsData_Puertorico(AgentIP,TagName,Status,SeverityID,EventCount,EarliestEvent,LatestEvent)" +
" values (@AgentIP,@TagName,@Status,@SeverityID,@EventCount,@EarliestEvent,@LatestEvent )" ,mySQLconnection);
sqlInsert.CommandTimeout = 0; //timeout unlimited
sqlInsert.CommandType = CommandType.Text;
sqlInsert.Parameters.Add("@AgentIP", SqlDbType.NVarChar).Value = agentIP;
sqlInsert.Parameters.Add("@TagName", SqlDbType.NVarChar).Value = tagName;
sqlInsert.Parameters.Add("@Status", SqlDbType.NVarChar).Value = Stat;
sqlInsert.Parameters.Add("@SeverityID", SqlDbType.Int).Value = Convert.ToInt32(severityId);
sqlInsert.Parameters.Add("@EventCount", SqlDbType.Int).Value = Convert.ToInt32(eventCount);
sqlInsert.Parameters.Add("@EarliestEvent", SqlDbType.DateTime).Value = DateTime.Parse(eEvent);
sqlInsert.Parameters.Add("@LatestEvent", SqlDbType.DateTime).Value = DateTime.Parse(lEvent);
sqlInsert.CommandType = CommandType.Text;
sqlInsert.ExecuteNonQuery();
mySQLconnection.Close();
}

View 4 Replies

Data Controls :: How To Use XML File To Store Offline Data

Oct 17, 2013

I am developing a application which is social related, and medical also, where there are lots of offline data which we have to show per user, insted of asking database for all the data, to reduce the preassure on the db server, i have thought of using xml for the offline data source.

When a user logs in, the old data will be loaded from the xml file from his folder which approx of ( less than 1 mb) each file). the updated info will be fetched from the db with the index of that table.

Can we use xml in getting data using writer and reader in vs 2012.

View 1 Replies

Forms Data Controls :: Unable To Read Data From Excel File To Gridview?

Mar 4, 2010

I am reading data from Excel file using oledbdataadapter and binding to gridview.Every thing working fine.but if the cell is having some text along with bar sysmol ( | ) [Ex : 12345 | 789123] that cell data is not reading from excel file.All fileds in excel sheet is text format only.Some times it's reading correctly & some times it not reading(empty).Is there any problem with bar symbol ( | )

View 1 Replies

Forms Data Controls :: Exporting Data From Two Gridviews To Two Sheets Of Same Excel File

Apr 6, 2010

I'm having two grid view and one button on aspx page , on click of export to excel button i want to transfer these grid view data to excel sheet.. My requirement is to trasnfer to same excel file with two sheets(One sheet for one grid view).

View 6 Replies

Data Controls :: Read Data From Excel File - Encrypt And Save In Database

May 7, 2015

I have an excel file with data as follows

ID     Name     Contact No    Address  
1      ABC        XXXXXXX     ABCNM2    
 XYZ         xxxxxxx       ASDFG

Now my requirement is read data from this excel sheet and den encrypt Contact No field for each row and den save data in database, how should it will be done I have to use some ready made available encryption algo for that. 

View 1 Replies

Data Controls :: Export GridView Data To Multiple Sheets In Same Excel File

Jan 24, 2016

I used this coding for export to excel, by using this coding i got only 65,536 rows only. How to bind more than 65,536 records or how to move the  balace records to sheet 2 by using this method.

Protected Sub btnExportExcel_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim ars_stock As New DataTable
ars_stock = cls.FillDataTable("select top 70000 * from spal..po_acc_details")
Response.Clear()
Response.Buffer = True

[Code] ....

View 1 Replies

Data Controls :: Update Existing Table Data By Uploading Excel File

Jan 24, 2016

Currently I was done to insert data thru upload excel file. May I know, how to UPDATE the existing data using iploading excel file.

View 1 Replies

Data Controls :: Loop And Insert Data Of All Sheets In Excel File To Database

Apr 23, 2014

I want to insert data in sql server from sheet within excelsheet ,there are three sheets in the file which i want to upload in three different tables,currently i am doing by selecting an individual sheet and the table to upload thus doing it three times for three sheets can i do it in one go,like passing all the sheets to a function or something like that or how can i do it in a better way and also i cannot directly upload sheet into table as i have to map one column of excel to different table of database to get its value like i need statecode but statename is provided in the sheet so i map statecode to statename in a staging table and then i upload the data...

View 1 Replies

Forms Data Controls :: Display Data In An Excel / PDF Or CSV File Format?

Apr 10, 2010

I'm building a User Control that will allow a user to select input parameters, run a query and then view the results in a GridView control. That part is obviously very easy. However, I've been asked to also provide the option of viewing and/or printing the data in a PDF, Excel or CSV file format.

Are there any .Net 2.0, built-in classes that allow for exporting and printing data in these formats in Visual Studio 2005?

A couple of years ago, I worked on a website that offered this functionality in Crystal Reports, but on this particular assignment, we aren't currently using Crystal - I'm not at work right now, and I can't remember if we're running the "Standard" or "Enterprise" edition of Visual Studio.

View 3 Replies

Data Controls :: Write Data To Excel File With Master Pages

Oct 21, 2015

 URL....the code works good when my webform is not inside content place holder of Master page.but, when i use same code in the webform which lies inside content place holder of a Master page, downloading of excel doesnot happen.

View 1 Replies

Forms Data Controls :: Unable To Export Data To An Excel File In Grid Format

Sep 7, 2010

I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines.I think I'm missing to set some property or somethnig ehwn exporting.

View 6 Replies

Forms Data Controls :: Export Gridview Data & Save In Excel File On The Server

Mar 31, 2010

I have code to export the grid to excel . i have taken it from [URL] now i want to save excel file directly without asking user to save it or open it at client side. i want to save it on server folder. how to do that .

View 2 Replies

Data Controls :: Edit Update Delete GridView With Data Imported From Excel File?

Mar 1, 2014

I am uploading an Excel file into DataSet/Gridview but once the file is uploaded, then i want to be able to make changes the data that is uploaded like making changes the data inside the Gridview or deleting the data etc.  Here is my code:

<div>
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_Click" />
<br />

[Code].....

View 1 Replies

Forms Data Controls :: Getting Data For Gridview From An Excel File

Aug 24, 2010

In my web page i'm having gridview control. The datasource of that control is retrieve from an excel sheet. how can i handle with this?

View 4 Replies

Data Controls :: How To Store Zip File In Database

May 7, 2015

1. How to store I ZIP file in Database using FileUpload in ASP.NET C#
2. Also need to downloading it from database by gridview

View 1 Replies

Getting Appending Html In Csv File (open In Excel) After Download From Server To Local Machine

Dec 9, 2010

I have created a CSV file on the server and want to send it to the user using the following code:

Dim strPhysicalPath As String
strPhysicalPath = Server.MapPath( "CSV/" & PathVirtual)
Dim objFileInfo As System.IO.FileInfo = New System.IO.FileInfo(strPhysicalPath)
Response.Clear()
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-Disposition", "attachment; filename=" & objFileInfo.Name)
Response.AddHeader("Content-Length", objFileInfo.Length.ToString())
Response.WriteFile(strPhysicalPath)
Response.Flush()
Response.End()

This seems to work fine except when the downloaded file is viewed in Excell the html code behind the page from which it came is also appended to the file. Does anyone have any idea why it does this?

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved