How to get the values into the textbox using datareader - ASP.NET Discussion Boards

Re: Problem with Ajax :TabContainer

jai_1017-May-09 3:01

jai_101

7-May-09 3:01

Hi,

Thank You for Your Reply.

Bye.
Rose | [Rose]

Referencing an object in the code behind

dptalt6-May-09 4:45

dptalt

6-May-09 4:45

I'm trying out this Office Viewer component on my aspx page. After adding the provided sample html code to the page the designer displays the object correctly. At runtime the control works too. But I cannot see this object in the code behind. I'm trying to use the Register tag but I cannot get it to work. How can I reference this object in the code behind?

Re: Referencing an object in the code behind

Jeff Circeo6-May-09 12:23

Jeff Circeo

6-May-09 12:23

are you talking about the office viewer component on www.ocxt.com[^]

if so... unless they changed something since i used it last, it's a brower pluggin not a component, I beleve you can not access it using the codebehind.

look at there samples to learn how to use it.

Take a look at my corner of the net at Code Research Center

How to get the values into the textbox using datareader in asp.net

Anjani Poornima6-May-09 4:35

Anjani Poornima

6-May-09 4:35

hi,

i am very new to this .net world.

I like to get the values from the database into the textbox using
datareader.

I tried in this way :

sqlcommand com=new sqlcommand(query,connectionstring);

datareader rdr=com.executereader();

while(rdr.read())
{
textbox.text=rdr["fieldname"].getstring();

}

But i failed to get the values

plz help me....in getting the values into the textbox using datareader

plz post the codesnippet how to do it

Thanx in advance Smile | :)

Re: How to get the values into the textbox using datareader in asp.net

Sujay chakraborty6-May-09 5:33

Sujay chakraborty

6-May-09 5:33

There could be few issues that u need to resolve for this code.

Firstly if you are having multiple rows in your database and you are trying to fetch those values in a single text box using DataReader then only the last record would be visible to you as the TextBox will be set to the last value only..... Secondly for using DataReader and SqlCommand you need an open connection so you need to specify an sqlconnection object and put it like

SqlConnection con = new SqlConnection();
con.Open();
sqlcommand com=new sqlcommand(query,con);
DataReader dr=com.ExecuteReader();
while(rdr.read())
{
textbox.text=rdr["fieldname"].getstring(); 
}
con.Close();

As DataReader is readonly and forward only so only the last value is available to the TextBox control. To avoid that and to retrieve all the values try some listbox or combobox. Best of luck!!!

Try hard but don't get stubborn

Re: How to get the values into the textbox using datareader in asp.net

Abhijit Jana6-May-09 9:53

Abhijit Jana

6-May-09 9:53

As you are new in .Net World,I will suggest you to buy some Beginners Book and start reading yourself. Which will help you learn better. Smile | :)

Good Luck !

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: How to get the values into the textbox using datareader in asp.net

SayreCC6-May-09 15:04

SayreCC

6-May-09 15:04

Hi, try this textbox1.text = rdr["fieldname"].tostring();

Hope this one can help.
Thanks

Hi, Please select Good Question if my answer are fit to your Question.

How to get the values into the textbox using datareader

Anjani Poornima6-May-09 4:30

Anjani Poornima

6-May-09 4:30

hi,

i am very new to this .net world

I like to get the values into the textbox using datareader.

I tried in this way :

sqlcommand com=new sqlcommand(query,connectionstring)

sqldatareader rdr=com.executereader();

while(rdr.read())
{
textbox.text=rdr["fieldname"].tostring();

}

but i am not getting the values into the textbox.

plz help me by posting the code.......

Thanx in advance Smile | :)

Re: How to get the values into the textbox using datareader

netJP12L6-May-09 4:36

netJP12L

6-May-09 4:36

double the column name, check if you have value for that field in the database.
check if you are even getting any rows. Also check if you are even coming into the while loop function let's say for instance.

while(dr.Read()
{
textbox.Text="I am here";///so at least you know some rows are being returned.
}

Re: How to get the values into the textbox using datareader

Abhijit Jana6-May-09 10:24

Abhijit Jana

6-May-09 10:24

Asking same question multiple times does not help you get better answer. Smile | :)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

properties and methods

netJP12L6-May-09 4:13

netJP12L

6-May-09 4:13

I find some funny behavour in VS 2005. When i type window. i get to see the focus method but when i do window.opener. i don't see the focus() method.

Although it works fine when i do window.opener.focus(); but my question is that how am i suppose to know if lets say focus() method is actually a real method and it's supported by the window.opener.

I am having real difficulties looking after what is supported and what's not.
Is there an Javascript API like how we have msdn2 for asp.net, C#.

I would be benefited from your insight.

Thanks

Re: properties and methods

Jeff Circeo6-May-09 12:29

Jeff Circeo

6-May-09 12:29

vs 2k5 isn't the best javascript writing tool.

vs 2k8 is better but still not that great.

learn the dom api instead of relying on intellisense you'll be glad you did. Big Grin | :-D

Take a look at my corner of the net at Code Research Center

CheckBoxList DataBinding on Postback [modified]

Swetha Sankaran6-May-09 3:53

Swetha Sankaran

6-May-09 3:53

I am trying to pass filter values from a webpart to a consumer. The vlaues are listed in a CheckBoxList. The databinding occurs in the GetValues method.
I have 2 issues:

a) When i select the values from the consumer web part(checkboxlist) and hit apply(i have added a imagebutton with autopostback attribute set to true) the checked values appear in a comma seperated string within a textbox but the values are lost after postback.

b) If I take the databind from getvalues and put it in Page_LoadComplete with if(!this.Page.IsPostBack) then, the values dont even appear in the checkboxlist.

How do i resolve this issue?
I'm pretty stumped. I've been staring at this thing for over 2 days now. Please find attached the code i'm working with. There is a javacript handler attached to the checkboxlist that correctly identifies the values selected. I guess it gets messed up on PostBack event.

       [ConnectionConsumer("Input Values")]<br />
       public void GetValues(ITransformableFilterValues values)<br />
       {<br />
           foreach (string val in values.ParameterValues)<br />
               {<br />
                   //this.Provider_Values += this.Provider_Values != " " ?","+ "'" + val +"'" : "'" + val + "'" ;<br />
                   this.Provider_Values = val;<br />
                   this.Provider_Name = values.ParameterName;<br />
                   ds = new SqlDataSource();<br />
                   ds.ID = "Source ID";<br />
                   ds.ConnectionString = cString;<br />
                   ds.SelectCommand = this.SQLSelectCommand;//"select distinct " + cName + " from " + tName + " where " + this.Provider_Name+ " = '" + this.Provider_Values+ "';";<br />
                   cBList.DataTextField = cName;<br />
                   cBList.DataValueField = cName;<br />
                   cBList.DataSource = ds;<br />
                   cBList.ID = "List ID";<br />
                   cBList.Attributes.Add("onclick", "FindSelectedItems(this," + tB.ClientID + ");");<br />
                   cBList.DataBind();<br />
               }<br />
           <br />
       }<br />
        public void BuildControls()<br />
           {  <br />
           try<br />
           {<br />
               cBList = new CheckBoxList();<br />
               this.Controls.Add(cBList);<br />
           }<br />
           //Sql exception cought.<br />
           catch (Exception ex)<br />
           {<br />
               ex1 = ex.Message;<br />
           }<br />
       }<br />
<br />
       protected override void CreateChildControls()<br />
       {<br />
           this.BuildControls();<br />
           base.CreateChildControls();<br />
       }<br />
<br />
       protected override void OnInit(EventArgs e)<br />
       {<br />
           this.Page.LoadComplete += new EventHandler(Page_LoadComplete);<br />
           base.OnInit(e);<br />
       }<br />
       <br />
       void Page_LoadComplete(object sender, EventArgs e)<br />
       {<br />
           if (this.Page.IsPostBack && !String.IsNullOrEmpty(this.Provider_Name) && String.IsNullOrEmpty(this.Provider_Values))<br />
           {<br />
               ds.SelectCommand = "select distinct " + cName + " from " + tName + " where " + this.Provider_Name + " = '" + this.Provider_Values + "';";<br />
               <br />
           }<br />
        <br />
       }

modified on Wednesday, May 6, 2009 1:09 PM

Timer Control in User control

scothykonma6-May-09 3:28

scothykonma

6-May-09 3:28

Hi All...

I am using Timer Control in User control (.ascx) page. In that page I placed the timer inside the updatepanel.

But wherever am using the usercontrol, that pages also have so many updatepanel. Because of that when every time the timer ticks, page should be refreshed.

The timer event works fine but the remaining like grid load should loaded once again.

Whats the problem....? How can I do it....?

Thanks in Advance.

Re: Timer Control in User control

Jeff Circeo6-May-09 12:31

Jeff Circeo

6-May-09 12:31

it sounds like you're not triggering an update on the gridview post some code I'll look at it.

or look into update panel triggers

Take a look at my corner of the net at Code Research Center

Localizing DateTime using microsoft report viewer [ RDLC ]

vbexpert16-May-09 2:27

vbexpert1

6-May-09 2:27

Hi,
i working on asp.net project ,
i want to localize the date in the report(rdlc),
if i use Hebrew Localization the date should be dd/mm/yyyy
and if i use English Localization it should be mm/dd/yyyy.
i am using date type in the dataset [set on local mode] - didn't help
i have tried to to change date to string and localize the date - didn't help.
what will solve this problem ?
Thanks,
Smile | :)

Roy.

bind textboxes runtime

Sneha Bisht6-May-09 1:20

Sneha Bisht

6-May-09 1:20

Hi , All i want to bind some textboxes at runtime . user enter values on that , and after that some calculation done .
i use panel for create textboxex at runtime , enter value , but cant retreive the values . how can i find all these textbox values

Regards Sneha

Re: bind textboxes runtime

Abhijit Jana6-May-09 2:03

Abhijit Jana

6-May-09 2:03

Sneha Bisht wrote:
Hi , All i want to bind some textboxes at runtime . user enter values on that , and after that some calculation done .
i use panel for create textboxex at runtime , enter value , but cant retreive the values . how can i find all these textbox values

In which event you are creating the TextBox. You have to create the control Before Page_Load(), other wise you will not able to get ViewState Data and PostBackData.
If you want to know more, please go through the ASP.NET Page Event LifeCycle.

Hope this will help you !!

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

domain check availability

nithydurai6-May-09 1:12

nithydurai

6-May-09 1:12

Hi everyone....is there any one having idea of domain check availability code in asp.net using C#....
I have a TextBox where user can enter the domain name as their wish.....and the next control is the DropDownList where user can select the extensions like .org,.com,.net etc and also there is a submit button and once if any one hit the submit button it shows whether the domain is available or not...and it should shows the result in the label..If anyone can help me out..and surely it will be appreciated...Advance thanks....

Re: domain check availability

Vimalsoft(Pty) Ltd6-May-09 1:18

Vimalsoft(Pty) Ltd

6-May-09 1:18

here you go

http://blog.skullwareinc.com/2008/10/11/CheckDomainAvailabilityInASPNetCWHOISLookup.aspx[^]

Vuyiswa Maseko

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

create Windows Service Project in VS2005 & VS 2008???

nkmkrishna6-May-09 0:51

nkmkrishna

6-May-09 0:51

Hi,

How to create Windows Service Project in VS2005 & VS 2008.

In my VS 2005 &2008 framework not have Windows Service Template.

If there any solutions pls tell me

Thanks,

NKM.

Re: create Windows Service Project in VS2005 & VS 2008???

Abhijit Jana6-May-09 1:01

Abhijit Jana

6-May-09 1:01