|
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 
|
|
|
|
|
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
|
|
|
|
|
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.
Good Luck !
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
}
|
|
|
|
|
Asking same question multiple times does not help you get better answer.
|
|
|
|
|
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
|
|
|
|
|
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. 
|
|
|
|
|
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 = 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;
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 />
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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,
Roy.
|
|
|
|
|
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
|
|
|
|
|
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 !!
|
|
|
|
|
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....
|
|
|
|
|
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/
|
|
|
|
|
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.
|
|
|
|
|
nkmkrishna wrote: In my VS 2005 &2008 framework not have Windows Service Template.
Not Possible !
Open Visual Studio > File > New Project > Visual C# > Windows > Windows Services
|
|
|
|
|
Are you using Express Edition ?
|
|
|
|
|
I am using Standard Edition.
|
|
|
|
|
Check this links
Link 1
Link 2
These may help
modified on Wednesday, May 6, 2009 8:35 AM
|
|
|
|
|
What You see what you get script(wysiwyg.js) for textarea is not working in content page
|
|
|
|
|
What problem are you getting ? How are you using the js file ?
|
|
|
|
|
In Master Page:
--------------
<head runat="server">
<script language="JavaScript" src="wysiwyg.js" type="text/javascript">
</script>
</head>
In Content Page:
----------------
<textarea id="textarea2" tabindex="2" cols="2000" runat="server" rows="10" name="message"
style="width: 529px"></textarea>
<script language="JavaScript" type="text/javascript">
generate_wysiwyg('textarea2');
</script>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
