ASP.NET

export dataset to excel file

26-Feb-09 8:53

Do you have a need for AJAX. That's it, really.

Christian Graus

Driven to the arms of OSX by Vista.

bhavna432125-Feb-09 23:03

bhavna4321

25-Feb-09 23:03

i want to export dataset at runtime to an excel file. i had tried but in vain. Pleaae help me with some link to work out.

Thnks in advance.

Re: export dataset to excel file

Tarini Singh26-Feb-09 2:10

Tarini Singh

26-Feb-09 2:10

Hi Bhavna,
The requirement is fissible via Gridview control or XmlDocument
but I think your requirement is without gridview,
We need to do the requirement as below

DataSet DS = somevalueDataSet();
XmlDataDocument xdd = new XmlDataDocument(DS);
XslTransform xt = new XslTransform();
string workingdir = AppDomain.CurrentDomain.BaseDirectory + "/" + "xslSheet.xsl";
xt.Load(workingdir);
string dirPath = AppDomain.CurrentDomain.BaseDirectory + "/" + "GeneratedFR";
string filePath = AppDomain.CurrentDomain.BaseDirectory + "/" + "GeneratedFR" + "/" + "Test1.xls";
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
File.Delete(filePath);
FileStream fs = new FileStream(filePath, FileMode.Create);
using(fs)
{
xt.Transform(xdd,null,fs);
fs.Close();
}

connect to the database?

che_kar25-Feb-09 22:47

che_kar

25-Feb-09 22:47

I Want to know about connect between asp page and sql sever.i Would like to know the varios ways to do that task.Give me any example coding about it.

please reply it me quickly.....

with regards

yrs che_karthik

Re: connect to the database?

N a v a n e e t h25-Feb-09 23:11

25-Feb-09 23:11

che_kar wrote:
I Want to know about connect between asp page and sql sever

This is very basic stuff. Please buy a good book on ASP.NET and work out the examples provided.

Navaneeth

How to use google | Ask smart questions

Live Broadcast

ashutosh kumar jha25-Feb-09 22:27

ashutosh kumar jha

25-Feb-09 22:27

Dear all,

I want to develop a live broadcast program in asp.net with c#, but i have no any idea about web cam related program. I already work on streaming technology for video site.

if anybody have web cam related program in asp.net then please ping me.

Thanks,

Ashutosh Kumar Jha

ashutosh kumar jha

Calendar?

Karthick_gc25-Feb-09 19:58

Karthick_gc

25-Feb-09 19:58

Hi, I am using a calendar control in my project. When i click on the date the control was post backed. My guide told to make the post back false. But thers is no post back property for that control. Can anyone tell how to achieve it?

Re: Calendar?

Christian Graus25-Feb-09 20:21

25-Feb-09 20:21

Karthick_gc wrote:
My guide told to make the post back false. But thers is no post back property for that control.

Your guide ? Is that like your boss ? There's no AutoPostBack property ? Perhaps you need a javascript calendar, the one built in to .NET kind of sucks.

Christian Graus

Driven to the arms of OSX by Vista.

Re: Calendar?

Karthick_gc25-Feb-09 20:29

Karthick_gc

25-Feb-09 20:29

Is there is any link to access the Javascript calendar?

Re: Calendar?

N a v a n e e t h25-Feb-09 21:03

copying rows from one gridview to another..

25-Feb-09 21:03

Here[^]. Looks like you need to read this[^] article.

Navaneeth

How to use google | Ask smart questions

scar_face25-Feb-09 19:54

scar_face

25-Feb-09 19:54

am using checkboxes to select rows in a gridview and once i click on the checkbox and click on transfer i want the selected rows to get displayed in another gridview..
heres the code .. but am getting Input array is longer than the number of columns in this table error message..
am stuck here...
DataTable dt = new DataTable();
foreach(GridViewRow dgr in GridView1.Rows)
{
if(((CheckBox)(dgr.FindControl("chkbx"))).Checked==true)
{
dt.Rows.Add(dgr);
}

GridView2.DataSource=dt;
GridView2.DataBind();

any help would be great appreciated..

scarface

Christian Graus25-Feb-09 20:28

25-Feb-09 20:28

scar_face wrote:
GridView1

scar_face wrote:
GridView2

This is for an obsfucation contest ?

Which line blows up ? I don't think a row can exist in two tables, I think you need to copy it.

Christian Graus

Driven to the arms of OSX by Vista.

scar_face25-Feb-09 20:59

scar_face

25-Feb-09 20:59

what i meant was to copy rows from one gridview to another gridview ..so can you help me with the code...it would be of great help..

scarface

Expert Coming25-Feb-09 21:13

Expert Coming

25-Feb-09 21:13

Google it, tons of results. But basically, you need to make a new DataRow, then copy the data column by column. Google will show you the way young padawan.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

getting error while taking output parameter in sybase procedure

scar_face25-Feb-09 23:29

scar_face

25-Feb-09 23:29

few lines of code would help me out...i did google a lot before posting in this forum..not much help over there for this thing..

scarface

Praneeth Babu K25-Feb-09 19:43

Praneeth Babu K

25-Feb-09 19:43

i ,
i am getting error's like,

Scale error during implicit conversion of NUMERIC value '195061.44' to a NUMERIC field.
Specified cast is not valid.

procedure with out put parameter as @v_End_Balance numeric(22, 2) out

in code i am giving as

cmdEndBal.Parameters.Add("@v_End_Balance", OdbcType.Numeric,22);
cmdEndBal.Parameters[2].Direction = ParameterDirection.Output;
cmdEndBal.ExecuteNonQuery();
Int32 RetVal = (Int32)(cmdEndBal.Parameters["@v_End_Balance"].Value

Re: getting error while taking output parameter in sybase procedure

Christian Graus25-Feb-09 19:49

how to create a link in data grid view

25-Feb-09 19:49

So change the type you're using, given that the given type 'is not valid'.

Perhaps casting a float to an int is the issue ?

Christian Graus

Driven to the arms of OSX by Vista.

susanta patra25-Feb-09 19:34

susanta patra

25-Feb-09 19:34

Please any body who knows how to create a link in data grid View..

Re: how to create a link in data grid view

Christian Graus25-Feb-09 19:50

How to pass values from javascript to server-side

25-Feb-09 19:50

You format a column to output a link. did you try google for examples ?

Christian Graus

Driven to the arms of OSX by Vista.

ratnakar_ravi25-Feb-09 19:20

ratnakar_ravi

25-Feb-09 19:20

How to pass values from javascript to server-side

Re: How to pass values from javascript to server-side

N a v a n e e t h25-Feb-09 19:24

Re: How to pass values from javascript to server-side

25-Feb-09 19:24

Using a hidden input field.

Navaneeth

How to use google | Ask smart questions

ratnakar_ravi25-Feb-09 19:26

ratnakar_ravi

25-Feb-09 19:26

can u give an example

Re: How to pass values from javascript to server-side

Christian Graus25-Feb-09 19:48

Re: How to pass values from javascript to server-side

25-Feb-09 19:48

1 - put a server hidden field in your page
2 - write the name of the field as a variable through to javascript, so you have the client side Id
3 - use document.getElementById to find the Id, and then set the value in JS
4 - on postback, read it from the hidden field.

Christian Graus

Driven to the arms of OSX by Vista.

N a v a n e e t h25-Feb-09 19:52