ASP.NET

Re: Really simple, but im missing something?! Binding to a label from a datasource in .net2 c#

28-Feb-07 23:08

Ive been using .net2 for a short while and have mastered the basics of using FormViews, DetailsViews and the like but I cant seem to see how to go about binding fields from a datasource to Labels?!

Can anyone please help, its driving me crazy? D'Oh! | :doh:

Thanks
Adam

gauthee28-Feb-07 23:52

gauthee

28-Feb-07 23:52

Didnt the DataBinder.Eval(Container.DataItem,"columnname") work???

Gautham

Re: Really simple, but im missing something?! Binding to a label from a datasource in .net2 c#

AdamskiR1-Mar-07 0:00

Re: Really simple, but im missing something?! Binding to a label from a datasource in .net2 c#

1-Mar-07 0:00

Thanks for the reply.

I dont know, how would i go about adding this? my heads in a right muddle! Id need to reference the datasource somewhere first though wouldnt i? How do I do this?

Adam

gauthee1-Mar-07 0:15

gauthee

1-Mar-07 0:15

No Problem!!!

Lets say that you have a gridview1 and the datasource given to the gridview1 is ds!!

Assume that the resultant ds has a table with 5 rows and 3 columns col a, col b, col c.

No in your grid under the itemtemplate you would have added the label right!
there you would just include the binding logic

ex:
<itemtemplate>
<as:label id="label1" runat="server">DataBinder.Eval(Container.DataItem,"col a")
.......
.......
......
......

Gautham

Re: Really simple, but im missing something?! Binding to a label from a datasource in .net2 c#

AdamskiR1-Mar-07 0:31

Re: Really simple, but im missing something?! Binding to a label from a datasource in .net2 c#

1-Mar-07 0:31

Its not linked with a gridview or anything as an item template, that part i can do.

Basically what i want is that there is a list of records in a listbox. You then can select a record which will then close the listbox and populate some labels with the persons email, name etc.

This is so that I can easily pull these records as I will want to add these into the database as it is part of a wizard form i am building for people to fill in.

Hope this makes sense.

Thanks
Adam

Harini N K1-Mar-07 0:20

Harini N K

1-Mar-07 0:20

Hi
There are lots of examples for form view using SQL Data Source. Here is an example to bind data in labels using VS.Net 2005 (C#.net 2.0)

Simply drag and drop SQL Data source in your application. Right click the Data source, click Configure Data Source. If this is the first time you are connecting to Database then Click New connection, Type Server Name, User Name & Password. Select database from the list after entering valid user name and password.

Connection String will be populated automatically in the list. Click next, select table from the list. You can modify your query later using the SELECT property of SQLDataSource.

If you don’t want SQLDatasource, you can add a connection string in Web.config and use the same. No need to worry about that now. You need to explore more on this.

For beginners, use SQL Data source. Try without DataSource later as most applications use Stored Procedures.

Now add Form or Details or Grid view in your application; go to DataSourceID property of the control (formview or detailsview or gridview). Select DataSourceID from the list as you have added in your application.

By default all fields will be bind automatically.

Just take a note: .net uses the following expression for binding text:

1.	<%# DataBinder.Eval(Container.DataItem,"columnname"%> - for gridview
2.	<%# Bind("Columnname") %> - for formview or detailsview 
3.	<%# Eval("Columnname") %> - for formview or detailsview

Try other controls like GridView. All the best

Rate this message. Thank you. Harini Smile | :)

Re: Really simple, but im missing something?! Binding to a label from a datasource in .net2 c#

AdamskiR1-Mar-07 0:40

Re: Really simple, but im missing something?! Binding to a label from a datasource in .net2 c#

1-Mar-07 0:40

Thanks for your reply.

BUt i wasnt looking to have the records in a form/details view as this would cause me problems on submitting the data as how would i find the actual labels within the controls when i want to submit the form?

Paddy Boyd1-Mar-07 0:40

Paddy Boyd

1-Mar-07 0:40

Very simple e.g.,

<br />
myLabel.text = dataTable.Rows(0).Items(0)

It depends on what your datasource is...

Re: Really simple, but im missing something?! Binding to a label from a datasource in .net2 c#

AdamskiR1-Mar-07 0:46

Re: question about grid view

1-Mar-07 0:46

Its a sqldatasource. What code would i need in to create the datatable from this in the first place?

Thanks

question about grid view

legend_of_zanado28-Feb-07 22:56

legend_of_zanado

28-Feb-07 22:56

i have a grid view with a template columns .. i put a button in one of the template column .. i want put the data in the first cell of the selected row in a string when i click on the button .. how ??

gauthee28-Feb-07 23:56

gauthee

28-Feb-07 23:56

This is the perfect link for your question. Check out!

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

Gautham

Datatable + asp.net 2.0 + c#

ritu432128-Feb-07 22:47

ritu4321

28-Feb-07 22:47

i want to create a datatable from FileInfoCollection object .Can you help me out .

how the sessions implemented?

M.S.Senthil Kumar.28-Feb-07 22:44

M.S.Senthil Kumar.

28-Feb-07 22:44

hai friends,
I already used cookies to transfer the value from one Webform to other.But in session concept it didn't work properly.

webform1
---------
session["session_name"]=100;

webform2
---------
int x;
x=session["session_name"];

The Session example of above is right?
if it wrong means? plz give the solution.

m.s.senthil kumar

Re: how the sessions implemented?

Tuwing.Sabado28-Feb-07 23:05

Tuwing.Sabado

28-Feb-07 23:05

int x;
x=(int)session["session_name"];

or

x=Convert.ToInt32(session["session_name"]);

Sending email message from asp.net webform

anujose28-Feb-07 22:40

28-Feb-07 22:40

How can i send an emailmesssage from my webform

swguy2328-Feb-07 22:49

swguy23

28-Feb-07 22:49

It's very easy to send and receve email in asp 2.0

first include following files in ur code filed

1)Imports System.Web.Mail
2)Imports System.Net

You can send mail in following way

' Creating the Mail Message

Dim objMailMessage As MailMessage

objMailMessage = New MailMessage
objMailMessage.From = "youremailaddress@yahoo.com"
objMailMessage.To = custemail.ToString
objMailMessage.Subject = "Subject Heading"
objMailMessage.Body = "Thank you (any Description in body)"

objMailMessage.BodyFormat = MailFormat.Html

' Sending Mail Message

SmtpMail.Send(objMailMessage)

'And also set ur Web.config file by defining your network host ipaddress, username and password

Regards,
Vidhin Shah

anujose28-Feb-07 23:13

28-Feb-07 23:13

where and how i will define in web config my network host ip address,username and password.

swguy2328-Feb-07 23:17

swguy23

28-Feb-07 23:17

<system.net>
<mailsettings>
<smtp from="youremail@yahoo.com">
<network host="xxx.xxx.xxx.xxx" password="abc" username="xyz">
(your network host ip address and username and password)

anujose28-Feb-07 23:29

28-Feb-07 23:29

in webconfig file how i will define that.can u send that coding

anujose1-Mar-07 0:01

1-Mar-07 0:01

my code is like this

MailMessage mail=new MailMessage();

mail.To ="anu@gmail.com";
mail.From ="anu2@gmail.com";
mail.Subject = "your subject";
mail.Body = "your subject";
SmtpMail.Send(mail);

it's executing.but i am not getting msg in my mail?what is the problem

swguy231-Mar-07 1:04

swguy23

1-Mar-07 1:04

hi i tried to paste the code but i dont know why its not displaying here so i have mailed the code to ur email address. so read that code and copy paste that code in ur web.config file

Regards,
Vidhin Shah

anujose1-Mar-07 18:32

1-Mar-07 18:32

i didn't get mail in my email why?..............