ASP.NET

21-Jan-07 17:41

Ah - you mean your dynamically created controls events do not run ? They need to be set up in the loadviewstate method, so that the viewstate for the controls is populated and the events can fire.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Re: UserControl Event

AnhTin21-Jan-07 17:47

AnhTin

21-Jan-07 17:47

thanks
yes i buiding a application load usercontrol dynamically
but can u show me more i still dont understand
Give me Example or some code Smile | :)

Re: UserControl Event

Christian Graus21-Jan-07 21:27

Radio Button List, Each Item in Table Column??? [modified]

21-Jan-07 21:27

I am not sure how I can make it clearer, You need to overload LoadViewState, and you need to load your control there, otherwise it doesn't exist when it needs to, for it to have it's controlstate restored.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

code-frog21-Jan-07 9:01

code-frog

21-Jan-07 9:01

Can you have each option in a Radio Button List be part of a table? So you can control the positioning etc... of the button list options?

Here is what I'm trying to pull off: http://www.codefrog.com/radiopage.gif[^]

Last modified: 12mins after originally posted --

Re: Radio Button List, Each Item in Table Column???

Christian Graus21-Jan-07 11:16

21-Jan-07 11:16

I think you can set how they fill the table they create ( how many across, how many down ). If you want more detailed control, I'd imagine you'd want to use a repeater.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

ADO.net

chohanpk21-Jan-07 6:21

21-Jan-07 6:21

i m using the tutorial "href="http://www.sitepoint.com/article/introduction-ado-net/3" to access values from database through ado.net using stored procedure.but its not working.here is my code

protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con= new SqlConnection("////here is my connection string/////");
con.Open();

SqlCommand com = new SqlCommand("ShowSuppliers", con);
com.CommandType = CommandType.StoredProcedure;
//SqlDataReader reader = com.ExecuteReader();
SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50);
parm.Direction = ParameterDirection.Input;
parm.Value = "US";
SqlDataReader reader = com.ExecuteNonQuery();
while (reader.Read()== true)
{
Response.Write(reader[0].ToString() + "
");

}

reader.Close();
con.Close();
}

and one of problem is whenever i m saving my procedure as in tutorial, it always chages "create PROCEDURE" with "ALTER PROCEDURE"

Chohan

Guffa21-Jan-07 6:30

21-Jan-07 6:30

If you would have provided some more specific information about what you mean by "not working", it would have been easier to spot the error.

The ExecuteNonQuery method does not return a data reader, it only returns an integer that represents the number of records affected. If you want a data reader, you should use the ExecuteReader method instead.

chohanpk wrote:
and one of problem is whenever i m saving my procedure as in tutorial, it always chages "create PROCEDURE" with "ALTER PROCEDURE"

That is normal. The create command is only used to create a procedure. The alter command is used to update the procedure when editing it.

---
Year happy = new Year(2007);

chohanpk21-Jan-07 6:44

21-Jan-07 6:44

but i m following the tutorial.when i m using the executenonquery,it gives the "int " error as u said.and when i m using ExecuteReader before sqlparamerters,as in tutorial,it gives error"Procedure 'ShowSuppliers' expects parameter '@txt', which was not supplied."
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con= new SqlConnection("Data Source=n-6e9a4f688df44;Initial Catalog=Northwind;Integrated Security=True");
con.Open();

SqlCommand com = new SqlCommand("ShowSuppliers", con);
com.CommandType = CommandType.StoredProcedure;

SqlDataReader reader = com.ExecuteReader();
SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50);
parm.Direction = ParameterDirection.Input;
parm.Value = "UK";
while (reader.Read()== true)
{
Response.Write(reader[0].ToString() + "
");

}

reader.Close();
con.Close();

}

.and when i used ExecuteReader after sqlparameter it shows nothing on output

protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con= new SqlConnection("Data Source=n-6e9a4f688df44;Initial Catalog=Northwind;Integrated Security=True");
con.Open();

SqlCommand com = new SqlCommand("ShowSuppliers", con);
com.CommandType = CommandType.StoredProcedure;

SqlDataReader reader = com.ExecuteReader();
SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50);
parm.Direction = ParameterDirection.Input;
parm.Value = "UK";
//SqlDataReader reader = com.ExecuteNonQuery();
//SqlDataReader reader = com.ExecuteReader();
while (reader.Read()== true)
{
Response.Write(reader[0].ToString() + "
");

}

reader.Close();
con.Close();
}

n for procedure i want to create a procedure then y its changed to Alter.i dont want edit any value. kindly check the tutorial.

Chohan

Guffa21-Jan-07 7:20

21-Jan-07 7:20

chohanpk wrote:
but i m following the tutorial.

That doesn't help the least bit when the tutorial is wrong.

chohanpk wrote:
when i m using ExecuteReader before sqlparamerters,as in tutorial,it gives error"Procedure 'ShowSuppliers' expects parameter '@txt', which was not supplied."

You have to set the parameter berfore calling the procedure. The procedure can not use a parameter that you add in the future.

chohanpk wrote:
n for procedure i want to create a procedure then y its changed to Alter.i dont want edit any value.

When you have created the procedure, it's displayed for you so that you can edit it. Even if you don't want to edit it, it's shown that way. To show it so that you could create it would be pointless, as you have already done that.

---
Year happy = new Year(2007);

chohanpk21-Jan-07 9:23

21-Jan-07 9:23

i give parameter befor but now it didnt show anything .just open a blank page.

protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con= new SqlConnection("Data Source=n-6e9a4f688df44;Initial Catalog=Northwind;Integrated Security=True");
con.Open();

SqlCommand com = new SqlCommand("ShowSuppliers", con);

com.CommandType = CommandType.StoredProcedure;

//SqlDataReader reader = com.ExecuteReader();
SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50);
parm.Direction = ParameterDirection.Input;
parm.Value = "UK";
SqlDataReader reader = com.ExecuteReader();
while (reader.Read() == true)
{
Response.Write(reader[0].ToString() + "
");

}
reader.Close();
con.Close();
}

will you plz tel me what will be the right code?
and how can i do it using execute "ExecuteNonQuery", also code for this.
thanks

Chohan

Guffa21-Jan-07 9:43

21-Jan-07 9:43

Do you have any suppliers in the database that matches the condition?

Have you tried "view source" on the page? As you are using Response.Write, you will be writing out the data before the actual html code. That will break the html code so that it might not show, but the data will be visible in the source of the page.

---
Year happy = new Year(2007);

chohanpk21-Jan-07 9:59

21-Jan-07 9:59

sorry i didnt understand what u asked? as i m begginer in asp.net.

Chohan

Guffa21-Jan-07 10:19

21-Jan-07 10:19

Exactly what was it that you didn't understand? If I have to explain everything assuming that you know absolutely nothing at all about it, it gets rather long...

---
Year happy = new Year(2007);

chohanpk21-Jan-07 10:50

21-Jan-07 10:50

tel me wats wrong in my code,
give me right code

Chohan

Christian Graus21-Jan-07 11:00

21-Jan-07 11:00

chohanpk wrote:
give me right code

It's not that easy. Without a copy of your database, he doesn't know what's wrong. He's told you how to work it out. If you can't work it out, abandon this project, work on something simpler, or at least buy a book and work through it.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Guffa21-Jan-07 11:03

21-Jan-07 11:03

chohanpk wrote:
tel me wats wrong in my code,
give me right code

I don't see anything wrong in your code. Except of course using Response.Write, but I already explained about that.

---
Year happy = new Year(2007);

chohanpk21-Jan-07 11:14

21-Jan-07 11:14

i m using the "northwind" database. n there are matching countries there like USA .
and what is "view source" kindly tel me.

Chohan

Guffa21-Jan-07 12:52

ASP.NET with C# -> online tutorial ?

21-Jan-07 12:52

chohanpk wrote:
and what is "view source" kindly tel me.

In the View menu in the browser you will find the option Source. That will show you the html code that was sent to the browser.

---
Year happy = new Year(2007);

Software_Specialist21-Jan-07 5:40

Software_Specialist

21-Jan-07 5:40

Hi
Can any one give me any good link for tutorial of ASP.NET with C#. I am a beginner in this programming world..
Thanks

Re: ASP.NET with C# -> online tutorial ?

Christian Graus21-Jan-07 11:02

Technical question: VS2003 and VS2005

21-Jan-07 11:02

Software_Specialist wrote:
I am a beginner in this programming world..

If you're a complete beginner, learn C# first, then learn ASP.NET. You should, in either case, buy a book and work through it. That will give you enough knowledge to be able to ask questions here, and understand the answers, and to read online tutorials, which tend to be focused on one subject. You need a basic grounding first, a foundation of general knowledge.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

sdsdsds@hotmail.com21-Jan-07 3:17

sdsdsds@hotmail.com

21-Jan-07 3:17

Hello.

I have a pc with visual studio 2005 working well.
I tried to install VS2003 along with the VS2003 so I can work on an old project built with VS2003 and FW1.1.

The problem is that when I'm tring to create a new asp.net project I'm getting the error:
"The webserver reported the following error when attempting to create or open the web project located at the following URL:'http://localhost/Webapplection1.'.'HTTP/1.1 500 Internal server Error'."

Those are the steps I took to try and solve it:
I checked that IIS is install.
I check that Front page extension is install.
The following FW are listed on my pc:
Microsoft .Net compact framework 1.0 sp3 developer
Microsoft .Net compact framework 2.0
Microsoft .Net framework 1.1
Microsoft .Net compact framework 1.1 HotFix
Microsoft .Net framework 2.0
I run the asp_regiis.exe -i.

Any idea what also should I check?
Is it because I need to install vs2003 first and then vs2005 (Ihope not!).

Thanks in advance,
Roy.

Re: Technical question: VS2003 and VS2005

Christian Graus21-Jan-07 11:03