ASP.NET

11-Jan-08 20:36

hi all.

i want draw my answer sheet result in a web page.

if there any way to draw it on a portion of page (for example a panel)?

i want to show it in side other information not in a empty page?

sepel

Datagrid Link Button

Shajeel11-Jan-08 20:33

Shajeel

11-Jan-08 20:33

I am using ItemDataBound event to add a Link button to a column using following code

LinkButton temp = new LinkButton();
temp.Click += new EventHandler(xyz);
temp.ID = e.Item.Cells[i].Text;
temp.CommandArgument = e.Item.Cells[i].Text;
temp.Text = e.Item.Cells[i].Text;

now when page is displayed i see these buttons but when i click on them, page is refreshed but Click event is not raised. how can i see which event control and which event is raised when i am clicking this link.

Regards
Shajeel

sepel11-Jan-08 22:03

11-Jan-08 22:03

when u click it only page_load raised.
i think that you'r plused event is null or empty.
if u add your event in page load each time there will be right.

sepel

Shajeel11-Jan-08 22:07

Shajeel

11-Jan-08 22:07

no its not null, i have a break point int the function but it is not fired.

Regards
Shajeel

sepel11-Jan-08 22:10

11-Jan-08 22:10

yes it raised but only page load is raised itrace some problem.
i add javascript to my buttons.
i hope u siolve it.

sepel

how can i retreive the login name programically?

Shajeel11-Jan-08 22:13

Shajeel

11-Jan-08 22:13

but i want to raise event for function xyz. post back is working but my code is in xyz.

Regards
Shajeel

Using Ajax

Member 387988111-Jan-08 19:55

Member 3879881

11-Jan-08 19:55

i am using asp.net1.1 version...,

Using ajax how to pass a form contained values to another page?,

Thanks & Regards,
Mageshh,
please don't forget to vote on the post

neodeaths11-Jan-08 19:41

neodeaths

11-Jan-08 19:41

hi i am trying to retrieve the login name programically in c sharp.net

currently i am using
formauthentication.redirectfromloginpage("username",false);
to login

i tryed to use the login view to retrieve the login name and it appear correct with the username: username

however i need to store the username in an variable for programming reasons any one know how this can be done?

Re: how can i retreive the login name programically?

pmarfleet11-Jan-08 22:13

how the dataset data is converted into

11-Jan-08 22:13

User.Identity.Name will give you the name of the logged-in user.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

jagan12311-Jan-08 19:06

jagan123

11-Jan-08 19:06

iam getting the data from database into the dataset and this iam assingn to the datatable but the dataset is containing one row with multiple columns how this data to be converted to one datacolumn with multiple data rows

Re: how the dataset data is converted into

pmarfleet11-Jan-08 22:10

Problem to read Excel worksheet

11-Jan-08 22:10

jagadeeshkumar2106 wrote:
the dataset is containing one row with multiple columns

Datasets don't contain rows or columns. Datasets contain tables, and the tables contain rows and columns.

You could perform the transposition in code, creating the output table dynamically by adding the required rows and columns.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Elena200611-Jan-08 18:40

Elena2006

11-Jan-08 18:40

Hi All,

There is the requirement to read Excel file and store data in a datatable for my web project. I am using C# language.

My code is written below

String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + excelFile + ";Extended Properties=Excel 8.0;";
objConn = new OleDbConnection(connString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [" + excelSheetName.Trim() + "]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
objAdapter1.Fill(dt);

The above code returns data to a data table, but the problem is to read formated Excel sheet. Suppose there is a formula field, it doesn't store the actual value. It stores some different value.

What other method to read the excel file? I am not using COM component of Excel to read as it is a web project. There may be a security problem after deployment. Frown | :(

Thanks in Advance. :

label control alignment

Pankaj Garg11-Jan-08 18:30

Pankaj Garg

11-Jan-08 18:30

i have a label control , How i should , make it's alignment to the center.

Re: label control alignment

sepel11-Jan-08 22:08

Re: label control alignment

11-Jan-08 22:08

u can use CssClass.

sepel

Pankaj Garg11-Jan-08 22:36

Pankaj Garg

11-Jan-08 22:36

ThanQ.I found an alternative
style="text-align:center"

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

Multiple solution files

jimbaloo11-Jan-08 14:25

jimbaloo

11-Jan-08 14:25

I am starting work on an web application that has the possibility of morphing into three distinct sites, an intranet, an extranet, and finally a website in the company's dmz. All three sites would access parts of the same database. What I want to do is to develop a central solution that contains all the common class libraries and handles all communication with the database.Then I would build a separate solution for each of the sites.
I have seen a similar scenario at a client I was not part of the development team and I'm not sure where to start, or how I would go about communicating with the central solution from any of the others.
I would really appreciate any pointers to get me started, the names of any books that would help, or any tutorials that deal with something of this scope.

Thanks.

ASP/C# - Can I Pass DataSet as Argument to EventHandler function? [modified]

cknight72511-Jan-08 9:53

cknight725

11-Jan-08 9:53

So, I posted over on the MS as.net forums, but I have to wait for moderator approval for the post to show, and frankly - I'd rather not wait.

I've been googling all over the net and not found an answer that I can completely understand -- heck I'm not even sure I have been googling the right terms.

I need to pass the contents of a DataSet to an ImageButton EventHandler function. The code I have right now errors cuz I believe the standard EventHandler doesn't allow arguments. I found some info on custom EventHandlers, but I don't really understand how to implement them. Here is the pertinenet code:

C# Script tag code:

<br />
public void exportClick(DataSet dat)<br />
{	<br />
    DataTable dt = dat.Tables[0];<br />
	DateTime dateStamp = DateTime.Now;<br />
	string file = dateStamp.Hour.ToString() + dateStamp.Minute.ToString() + dateStamp.Second.ToString();<br />
    CreateCSVFile(dt, Server.MapPath("/csv_export/export"+file+".csv"));<br />
}<br />
		sql = "SELECT......";<br />
		dat=readDb(sql);<br />
<br />
		//Place Export Button in Panel on Web Page<br />
		ImageButton ib = new ImageButton();<br />
		ib.ID = "exportButton";<br />
		ib.ImageUrl = "./img/export.png";<br />
		ib.Width = 110;<br />
		ib.Height= 25;<br />
		ib.AlternateText="Export to CSV";<br />
		ib.Click += new EventHandler(exportClick(dat));<br />
		Panel1.Controls.Add(ib);<br />

And the HTML:

<br />
<body><br />
   <form runat="server"><br />
   ......<br />
     <asp:panel id="Panel1" runat="server" height="25px" horizontalalign="right" /><br />
   ......<br />
   </form><br />
</body><br />

So ideally what should happen is that the user clicks on ImageButton "ib", which fires the exportClick(dat) function and a CSV file is created from the DataSet "dat". If I can get this working, I have code to fire a file download of the CSV that will get stuffed in as well, but I deal with that once I have a CSV.

Thanks in advance!

modified on Friday, January 11, 2008 4:10:00 PM

Re: ASP/C# - Can I Pass DataSet as Argument to EventHandler function?

pmarfleet11-Jan-08 10:53

Re: ASP/C# - Can I Pass DataSet as Argument to EventHandler function?

11-Jan-08 10:53

I'm not sure I agree with the logic of your approach. Wouldn't it be better to build the CSV file after the user has clicked the 'Export' button? After all, if the user doesn't click the button then the effort of fetching the data and building the file has been wasted. I would create the file when the user chooses to export the data and stream the data back directly from memory. This cuts out the overhead of having to write to the file system.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

cknight72511-Jan-08 11:02

cknight725

11-Jan-08 11:02

Not sure I understand -- the CSV (hopefully) doesn't get created until the user triggers the "onclick" event that triggers my exportClick(DataSet) function -- question is how do I get there?

Re: ASP/C# - Can I Pass DataSet as Argument to EventHandler function?

pmarfleet11-Jan-08 11:08