Re: Gridview - ASP.NET Discussion Boards

Re: Does AJAX can get ColumnName at client?

Edbert P13-Jul-06 19:19

13-Jul-06 19:19

What was the error returned?
ds.Tables[0].Columns[0].ColumnName should work unless your dataset is null or contains no tables, or the table has no columns at all.

BTW, why are you using alert? If you mean to access the dataset from Javascript, you need to convert the dataset into either an XML or Javascript array first.

"You are special, but so is everybody else."

"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross

Edbert
Sydney, Australia

Master/Detail [modified]

deepaks313-Jul-06 10:12

deepaks3

13-Jul-06 10:12

Hi,
I have two problems,

First I want to show the master details data in a single grid (or a grid within a grid or a repeater within a repeater).
The structure what I want is something like, On the first column i ant to sho different rows which have the info about the master say customerid , customer name ,customer address.
And in the second column there will be all the details rows, which will contain multiple orders.
Actually it should look like in a table its only two colums.

I hope i am clear enough.

Secondly,I dont want to edit any record, i just want to display them.
So which control should i use, Repeater,DataView or grid.

Please provide me with the link or a sample code in C#.

Thanks in advance.

Deepak Surana

-- modified at 16:13 Thursday 13th July, 2006

Re: Master/Detail

leckey13-Jul-06 10:45

leckey

13-Jul-06 10:45

I recently went through the learning of master/detail grids. All I can say is if you don't want to edit--good! It will make life easier. Smile | :)

There are lots of articles but the ones I found most helpful were the 18 part series on datagrids at 4guysfromrolla. This is the link to part 18 but it has links to the other ones. Part 14 is the master/detail article.

http://aspnet.4guysfromrolla.com/articles/061505-1.aspx

If you use the datagrid you will use ItemTemplate for your columns. Basically it's like a datagrid, and then creating another datagrid inside of it for the detail stuff.

There are some articles here for nested datagrids (I'd search on those keywords) that also show how to insert drop-downs and things like that. But personally, I really like that 18 part series, especially if you have never worked with datagrids.

I don't know if someone else feels Repeater or DataView is better, but I had not programmed asp.net in a looong time and I eventually got it.

Feel free to go through the articles and post again if you have more specific questions.

Have fun!

Re: Master/Detail

deepaks317-Jul-06 7:44

deepaks3

17-Jul-06 7:44

Hey!
I think datagrid, repeater would be more easy and efficient to use.
The article is nice, but can you please help me out in finding a code in C#.

Thanks !

Deepak Surana

Re: Master/Detail

leckey17-Jul-06 8:07

leckey

17-Jul-06 8:07

You're just looking for the code to connect to the database? Because all the datagrid setup (columns, headers and such) is done in the asp part.

Re: Master/Detail

deepaks317-Jul-06 19:46

deepaks3

17-Jul-06 19:46

Hi,
I have checked out the complete code, but i require the code in C#.

Gridview

kjosh13-Jul-06 9:15

kjosh

13-Jul-06 9:15

Hi,
I want to display data into gridview.I wrote the following code;
string str="Data Source=KALSYSTE-X6VVC3\\SQLEXPRESS;Trusted_Connection=yes;Initial Catalog=Northwind";
SqlConnection con = new SqlConnection(str);
SqlDataAdapter da = new SqlDataAdapter("select * from employees",con);
DataSet ds = new DataSet();
da.Fill(ds, "employees");
GridView1.DataSource = ds;
GridView1.DataBind();

When i run the application,it is giving the following exception:
Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition.

Please help me.
Thanks in advance

Re: Gridview

minhpc_bk13-Jul-06 15:29

minhpc_bk

13-Jul-06 15:29

The error message is clear enough and also gives you the solution. You basically use either the DataSource or DataSourceID to bind data to the GridView control.

Re: Gridview

albCode13-Jul-06 21:24

albCode

13-Jul-06 21:24

Did you initialize DataSourceID for your GridView? If yes, comment or delete that line and run your app.

Saving\Reading Configuration parameters in a WebService.

Gilad Kapelushnik13-Jul-06 6:22

Gilad Kapelushnik

13-Jul-06 6:22

Hello.

I'm writting a web service which is constructed of some DLLs.
Each dll has its configuration properties.

I would like to be able to save & read these configuration paramaters in files (a file for each DLL) during runtime. I found endless classes from Framework 2.0 that claim to do this but haven't found nothing that saves the configuration to a simple file and reads it back in a simple manner.

In the Configuration namespace I found a way to save paramaters. I constructed a ConfigurationSection and was able to save it into a file but found no way to read it (very strange to find a SaveAs mathod without a Read method). Just saving it would create a XXX.exe.config which isn't going to work for the webservice.

Any ideas ?

Gilad.

Re: Saving\Reading Configuration parameters in a WebService.

minhpc_bk13-Jul-06 16:30

minhpc_bk

13-Jul-06 16:30

Hi there,
Here are a couple of tips which are already documented in MSDN:

+ You can use the methods of the ConfigurationManager or WebConfigurationManager to open the config file, and these methods basically return the Configuration object.

+ The Configuration object provides you with the GetSection, GetSectionGroup to read the configuration settings, and the Save, SaveAs methods to save the settings.

Trying to print an html page without to load it in asp.net

sai_akkina13-Jul-06 5:11

sai_akkina

13-Jul-06 5:11

Hi,
I am facing a problem in my web application while i am trying to print an html page, whose url is specified in a textbox, using axWebBrowser component. I am getting an error "Exception of type InvalidActiveXStateException was thrown", at axW.Navigate statement. Please help me to rectify this problem.

private void Button1_Click(object sender, System.EventArgs e)<br />
{<br />
	try<br />
	{<br />
		object empty= null;<br />
		System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(WebForm1));<br />
		AxWebBrowser axW=new AxWebBrowser();<br />
		axW.Enabled=true;<br />
		axW.Visible=false;<br />
		axW.OcxState = (System.Windows.Forms.AxHost.State)(resources.GetObject("axW.OcxState"));<br />
		//Response.Write(axW.OcxState.ToString());<br />
		axW.Navigate(TextBox1.Text,ref empty,ref empty,ref empty,ref empty);<br />
		axW.ExecWB(SHDocVw.OLECMDID.OLECMDID_PRINT,SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER ,ref empty,ref empty);<br />
	}<br />
	catch(Exception Ex)<br />
	{<br />
		Response.Write(Ex.Message.ToString());<br />
	}	<br />
}

Thanks,
Sai.

Re: Trying to print an html page without to load it in asp.net

Not Active13-Jul-06 5:23

Not Active

13-Jul-06 5:23

Don't cross post your question and you may get answer Mad | :mad:

PasswordRecovery and programmatically setting mailSettings

Barry Etter13-Jul-06 5:10

Barry Etter

13-Jul-06 5:10

Hi. Is it possible to set the SMTP settings for the PasswordRecovery control from code rather than having it in the web.config file (in the System.Net -> mailSettings element)?

I use the same code for several different applications and I want the e-mails to come from the various application e-mail address rather than just one hard-coded in the web.config file.

I would like to set the SMTP server, username, password, etc. in the Page_Load() event, for example.

None of the docs or Google hits I found addressed this for the PasswordRecovery control. I found examples of sending generic e-mails, but none address the PasswordRecovery control.

Thanks!

Barry Etter

Re: PasswordRecovery and programmatically setting mailSettings

Mike Ellison13-Jul-06 6:18

Mike Ellison

13-Jul-06 6:18

I think I see what you mean. You can set a bunch of subproperties of the MailDefinition object in code from Page_Load(), but you can't specify the server. And MailDefinition is read-only, so you can't create a different one.

You could always handle emailing the password manually, and construct a MailMessage yourself instead of using the PasswordRecovery's built-in email capability, using an SmtpClient object to send it.

ASPEXEC DLL

vfhgujaqwe13-Jul-06 5:05

vfhgujaqwe

13-Jul-06 5:05

Has anyone used the aspexec dll? If so, where can it be downloaded?

What I'm trying to do is determine the person signing into my webpage is accessing the webpage from their computer. Does anyone know code or software I can use for this, other than aspexec dll?

Thank You.

zxcvbnm

How can I put the line breraks in a message??

malalation13-Jul-06 5:05

malalation

13-Jul-06 5:05

Hello,
I made two asp.net pages with VB.Net code, the first page is to post a message to the acceess data base, and the second page contains a repeater wich shows all the messages in the access database, but the repeater shows the posted messages without any line breaks. (line1. line2)
so what is the solution??

Note: I'm using VB codes

Thanx

Re: How can I put the line breraks in a message??

Paddy Boyd13-Jul-06 5:56

Paddy Boyd

13-Jul-06 5:56

What's your sql?

What does your repeater look like?

Re: How can I put the line breraks in a message??

malalation14-Jul-06 11:06

malalation

14-Jul-06 11:06

it's a microsoft access 2003 database.

and here is my repeater's code:

<asp:repeater id="rptGuestbook" runat="Server">
<headertemplate>

<itemtemplate>

<separatortemplate>

<footertemplate>

<%# Container.DataItem ("Name") %>
E-mail:	<%# Container.DataItem ("EMail") %>
Website:	<asp:hyperlink id="HyperLink" runat="server" font-names="Tahoma" font-size="X-Small" navigateurl="<%#" container.dataitem="" ("url")="" %="">> <%# Container.DataItem ("URL") %>
Comment:	<%# Container.DataItem ("Comment") %>

Re: How can I put the line breraks in a message??

Guffa13-Jul-06 20:33

Guffa

13-Jul-06 20:33

When you display the text, html-encode the text, then replace the line breaks (Environment.NewLine) with "<br>" (or "<br />").

---
b { font-weight: normal; }

loading usercontrol templates dynamically from database

For_IT13-Jul-06 3:28

For_IT

13-Jul-06 3:28

Hi all

I have created usercontrol templates and stored the template code in database. The templates are for instance postcards, visiting cards etc..

I want to load these usercontrol templates dynamically to my web page. I referred to http://aspalliance.com site where the author has mentioned about use of usercontrol templates...
I want to know how I can load the the usercontrol using the template code from database on the web page...
please help me...
thanks in advance...

Re: loading usercontrol templates dynamically from database

Mike Ellison13-Jul-06 6:43

Mike Ellison

13-Jul-06 6:43

Hi there. A UserControl, as a subclass of TemplateControl can use the LoadControl() method to load a usercontrol given a virtual file path. Unfortunately, there isn't an override that allows you to load a usercontrol given a string (which could be fed by your database source).

However... in ASP.NET 2.0 we now have the
VirtualPathProvider[^] class. It seems to me you may be able to build your own VirtualPathProvider to intercept requests for ".ascx" files and instead get that data from the database.

That sounds like a pretty good concept for a CP article...

Re: loading usercontrol templates dynamically from database

minhpc_bk13-Jul-06 15:33

minhpc_bk

13-Jul-06 15:33

Just want to second Mike's suggestion with the VirtualPathProvider class.

How to use virtual path providers to dynamically load and compile content from virtual paths in ASP.NET 2.0[^]

Date Difference

leelaraj13-Jul-06 1:46

leelaraj

13-Jul-06 1:46

Hi all,

how to calculate number of days between two days e.g

from date 01/07/2006 To date is 10/07/2006.. i want to calcilate no.of days.

Help me urgent. in asp.net

Re: Date Difference

Paddy Boyd13-Jul-06 2:02

Paddy Boyd

13-Jul-06 2:02

DateTime aDate;
DateTime anotherDate;

Timespan diff;

diff = aDate.Subtract(anotherDate);

Timespan has properties like days, years etc.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.