Re: export dataset to excel file - ASP.NET Discussion Boards

nkmkrishna26-Feb-09 0:00

26-Feb-09 0:00

hi to All,

What is Content Management System(CMS) & Knowledge Management System(KMS)?
how CMS relates with KMS?
Advandages & disadvandages of CMS & KMS??

Thanks,
NKMKrishna

Re: Relation with CMS & KMS

J4amieC26-Feb-09 0:12

J4amieC

26-Feb-09 0:12

nkmkrishna wrote:
What is Content Management System(CMS)

Its is a system which manages content

nkmkrishna wrote:
Knowledge Management System(KMS)

It is a system which manages Knowledge.

nkmkrishna wrote:
how CMS relates with KMS?

Im guessing sometimes there is content associated with knowledge.

further reading[^]

How can I send image tage in Response.Write

Naveed72725-Feb-09 23:56

Naveed727

25-Feb-09 23:56

Hello All,

I want to send image tag in Response.Write how can I achieve this..
I am doing like this
Response.Write(" ");

know the problem I have is I am giving creating multiple images, that should be at the location of control where I am using it.
But It is not working ....

Any suggestion what should i do.....

Thanks in advance

Regards
Confused | :confused:

Re: How can I send image tage in Response.Write

Anurag Gandhi26-Feb-09 1:29

Anurag Gandhi

26-Feb-09 1:29

Try Single quote,
Response.Write(" <img alt='' src='Images/2.jpg' style='height: 37px; width: 40px' />");

This should work.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Opinion about ajax

Shyam K Pananghat25-Feb-09 23:33

Shyam K Pananghat

25-Feb-09 23:33

What are the main pain points of ajax. what are the point/decisions we need to consider before deciding to go for an ajax based framework in our application

Shyam..

My Blog dotnetscoups.blogspot.com

Re: Opinion about ajax

Christian Graus26-Feb-09 8:53

Christian Graus

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.

export dataset to excel file

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

N a v a n e e t h

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

Christian Graus

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

N a v a n e e t h

25-Feb-09 21:03

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

Navaneeth

How to use google | Ask smart questions

copying rows from one gridview to another..

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

Re: copying rows from one gridview to another..

Christian Graus25-Feb-09 20:28

Christian Graus

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.

Re: copying rows from one gridview to another..

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

Re: copying rows from one gridview to another..

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

Re: copying rows from one gridview to another..

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

getting error while taking output parameter in sybase procedure

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

Christian Graus

25-Feb-09 19:49