ASP.NET

ASP.net/SQL newbie Question

31-Jan-07 14:15

What you are asking here is really basic, you simply take the input value from the login form then execute a simple query against DB to select the value. There are tons of tutorials out there that you can learn, you might also download the starter kits from the Microsoft ASP.NET site to learn from them.

Re: login form

ed^nrgc1-Feb-07 3:53

ed^nrgc

1-Feb-07 3:53

You get it like this:

LoginControl1.UserName.Trim();

Planker31-Jan-07 11:02

Planker

31-Jan-07 11:02

I followed the article here http://www.kirupa.com/net/sql_asp_introduction.htm

everything compiles ok but when it get to opening the database I get error message
An attempt to attach an auto-named database for file C:\Path\Games.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share

I do not have any other databases with the same name and it is on the C drive so leads me to believe for some reason it can not open the database.

could someone please help me with this.
Thanks

Re: ASP.net/SQL newbie Question

minhpc_bk31-Jan-07 14:10

You can check out here[^]

31-Jan-07 14:10

Re: ASP.net/SQL newbie Question

Planker31-Jan-07 16:47

Planker

31-Jan-07 16:47

ok i figured out what was wrong, .net 2.0 needed to be reinstalled, my app now runs but does not write to the database, is there something wrong with my code to write to the database?

SqlConnection connection;
protected void Page_Load(object sender, EventArgs e)
{
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["GameConnection"].ConnectionString);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SqlCommand command = new SqlCommand("INSERT INTO gameTable(gameName, gamePlatform) VALUES (@id_gameName,@id_gmaePlatform)", connection);
SqlParameter nameContent = new SqlParameter("@id_gameName", SqlDbType.VarChar);
nameContent.Value = txtName.Text;
command.Parameters.Add(nameContent);

SqlParameter platformContent = new SqlParameter("@id_gamePlatform", SqlDbType.VarChar);
platformContent.Value = txtPlatform.Text;
command.Parameters.Add(platformContent);

connection.Open();
command.BeginExecuteNonQuery();
connection.Close();

Response.Redirect("Results.aspx");
}

Re: ASP.net/SQL newbie Question

minhpc_bk1-Feb-07 0:08

Clicking on data in a GridView

1-Feb-07 0:08

Planker wrote:
command.BeginExecuteNonQuery();
connection.Close();

You make an asynchronous call to insert data, but you close the connection right after that then how data can be inserted into DB. You might also double check the parameter name gmaePlatform as well.

dptalt31-Jan-07 10:22

dptalt

31-Jan-07 10:22

I have a GridView that displays rows of pictures along with text that describes the pictures. When I click on the picture I would like another page to display. How do I write an event for that, or can I configure the Imagefield in the GridView to do this? Thanks.

Re: Clicking on data in a GridView

minhpc_bk31-Jan-07 14:09

Re: Clicking on data in a GridView

31-Jan-07 14:09

AFAIK, the ImageField does not allow you to define the event handler in the field markup, instead you'll need to use the RowCreated/RowDataBound event of the GridView control and try to get reference to the Image control, then register your event handler script. Another option is to use the Image control with the TemplateField in lieu of the ImageField and you can easily add the event handler for the Image control in the template.

badgrs31-Jan-07 22:23

badgrs

31-Jan-07 22:23

You shouldn't need any event handlers, a template field with an image link will do the trick.

currentdate

saravanan0531-Jan-07 10:20

saravanan05

31-Jan-07 10:20

hi friends

i want display the current date in textbox.how can i bind the date with c#,asp.net

plz give me the code

regards
saravanan

Re: currentdate

Guffa31-Jan-07 10:49

Guffa

31-Jan-07 10:49

SomeTextBoxThatYouHave.Text = DateTime.Now.ToString("d", TheFormatInfoOrCultureInfoThatYouWantToUse);

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

saravanan0531-Jan-07 11:14

saravanan05

31-Jan-07 11:14

hi
thanks for reply

i want currentdate only.i dont want time.date is dd/MM/yyyy this format

regards
saravanan

Guffa31-Jan-07 13:52

Guffa

31-Jan-07 13:52

You can't get only a date. The DateTime structure is used to handle dates and times, and there is no Date structure wihtout time. The time is always there, even if it's 0:00, it's still there. It's no problem, though, as you choose what you want to display when you convert the DateTime value to a string.

The formatting string that you use in the call to ToString determines the format. The "d" string specifies the use of a short date format. The short date format is depending on the culture, so you should specify a FormatInfo or CultureInfo object to determine the culture to be used.

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

Venkatesh Mookkan31-Jan-07 15:38

Venkatesh Mookkan

31-Jan-07 15:38

Try like this,

sometextbox.Text = Now.ToString("dd/MM/yyyy")

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group

Accessing events from outside

Christian Graus31-Jan-07 16:04

Christian Graus

31-Jan-07 16:04

If you call DateTime.Now.ToShortDateString(), you will get a string that is locale correct.

Christian Graus - C++ MVP

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

Jazeee31-Jan-07 9:52

Jazeee

31-Jan-07 9:52

Is there any way to handle event(maybe some custom) raised by ASP.NET page in outer application(of course in .NET platform)? I am running Windows Form and start ASP.NET server from form. And data received from web should be processed in form too.

minhpc_bk31-Jan-07 14:00

31-Jan-07 14:00

I believe that there are a couple of options to notify the Windows Form ( or an outer .Net application in general), for example .Net remoting, MSMQ, ....

Jazeee31-Jan-07 15:15

Jazeee

31-Jan-07 15:15

I believe this too;) But would be great to know HOW should I do Smile | :)

minhpc_bk31-Jan-07 15:31

31-Jan-07 15:31

Assuming you use the .Net Remoting, briefly your Window application can host an object that can be called remotely from an outer application like the ASP.NET application. Whenever a custom event happens in the ASP.NET application, you can send a request from the ASP.NET application to notify the Windows application via this remote object about this event as well as the event-related data sent along with the request. For more information, sample code, and how-tos you can see Remote Objects[^]

Jazeee31-Jan-07 16:53

Jazeee

31-Jan-07 16:53

Thanx for this - remoting is quite usable. But maybe there is a way to pass objects inside system? I mean that would be great if objects will not be able to come out from local machine .NET system.

payback31-Jan-07 17:22

payback

31-Jan-07 17:22

Whats the catch????

minhpc_bk31-Jan-07 18:39