|
I am new to ASP .NET.
I want to retrieve values from database and show them in textboxes on page load.
i use dataset, sqldataadapter etc..
I need some help in this coding...
con.Open();
cmd.Parameters.Add("@EID", SqlDbType.Int).Value = Convert.ToInt16(txt_eid.Text);
cmd.ExecuteNonQuery();
con.Close();
ds = new DataSet();
i am not sure what to code....
where to get the values from...?
please help.....
SAJAN A PILLAI
C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
Hi !
you can do something like this.
DataSet ds=new DataSet() ;<br />
try<br />
{<br />
SqlDataAdapter adapter; <br />
cmd.Connection.Open(); <br />
adapter = new SqlDataAdapter(cmd); <br />
adapter.Fill(ds);<br />
cmd.Dispose();<br />
adapter.Dispose();<br />
return ds;<br />
}<br />
catch<br />
{<br />
cmd.Connection.Close();<br />
}<br />
<br />
Hope this will help you to solve the problem.
Regards.
|
|
|
|
|
Hi guys
I have a gridview hyperlinkfield as show below:
<asp:HyperLinkField DataNavigateUrlFields="Item_Ref, Item_Description" DataTextField="Item_Ref" HeaderText="Item_Ref" SortExpression="Item_Ref" DataNavigateUrlFormatString="~/Main/RoomCompdets.aspx?firstvar={0}" Target="_new" />
How would i put into this code above the following code:
"window.open (this.href, 'popupwindow','width=850,height=700,scrollbars,resizable');return false;">
thanks in advance!!
Basically I just want to open a new browser window to a set size from a gridview hyperlinkfield
|
|
|
|
|
Can we create Rich Text Box in ASP.NET
|
|
|
|
|
There is no inbuilt control available. Use third party programs like FCKEditor or TinyMCE.
|
|
|
|
|
Hi
I have the below code and what I would like it to do is when I click on the button a panel will appear, click on it again and it will dissapear. Thats all but the below code doesnt seem to work can any1 point me in the right direction?
thanks
<asp:Button ID="btn_search_by_area1" runat="server" Text="Search Sub Dep." />
<atlas:UpdatePanel ID="UpdatePanel2" runat="server" Mode="Conditional" >
<ContentTemplate>
fdgdfgdfg
</ContentTemplate>
<Triggers>
<atlas:ControlEventTrigger ControlID="btn_search_by_area1" EventName="Click" />
</Triggers>
</atlas:UpdatePanel>
</asp:Content>
|
|
|
|
|
Have you thought of using JavaScript and not using the UpdatePanel control at all? From experience the UpdatePanel is not a great control and if all you are looking to do is toggle the display of a block-level element, then the following would be far easier in my opinion:
Your JavaScript...
<br />
function toggleDisplay(toggleDiv)<br />
{<br />
toggleDiv = document.getElementById(toggleDiv);<br />
<br />
if (toggleDiv.style.display != 'none')<br />
toggleDiv.style.display = 'none';<br />
else<br />
toggleDiv.style.display = 'block';<br />
}<br />
Your HTML...
<br />
<asp:Button OnClientClick="toggleDisplay('toggleDiv'); return false;" ID="btn_search_by_area1" runat="server" Text="Search Sub Dep." /><br />
<div id="toggleDiv"><br />
ghjgjhgg<br />
</div><br />
Clean code is the key to happiness.
|
|
|
|
|
hi friends
Any body use Skelta...
Known Is Drop.Unknown Is Ocean
|
|
|
|
|
plz help me.....
i have to display data in gridview asp.net 2.0.problem is that one of my column contains text box in gird view?i have to update another column's value of gird view based on text box 's value of gird column, without sending it to server?lest we have three columns in grid view current price, discount (text box),and cusomter price .here suppose current price is 100 and user entering 10% discount then it should show 90 in customer price list without sending request to server or any update button event?i m using asp.net 2.0, c#, sql server200?
|
|
|
|
|
Try this one
gridview1.rows[rowno][colno] = mathematical calculation
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
this can be done using script.
use the script function below..
function FindPrice(ctlCurrentPrice,txtDiscount,ctlCustomerPrice)
{
ctlCustomerPrice.innerText = Number(ctlCurrentPrice.innerText)-
Number(ctlCurrentPrice.innerText)*Number(txtDiscount.value)/100);
}
and use the following code inside the RowDataBound event of gridview..
if (e.Row.RowType == DataControlRowType.DataRow)
{
TextBox txtDiscount = e.Row.FindControl("txtDiscount") as TextBox;
txtDiscount.Attributes.Add("onchange", "FindPrice(" + e.Row.Cells[0].ClientID + ",this," + e.Row.Cells[2].ClientID + ")");
}
|
|
|
|
|
1. I have the following tables in the sql server
(a) tblforms - This table contains all the form names of the project
(b) tbluserdetails - This table contains the user information
(c) userforminfo - this table contains the information about which form pertains to which user.
2. I have a web form named form management , there in the form , i have the dropdownlist and a gridview.
in the gridview , i have two columns (formname , checkbox)
Dropdownlist populates all the user names , and the currently selected user name in the dropdownlist selects the form name in the checkbox of gridview .
Now my question is , how should i select the form name for the particular user and leave the rest unselected in the checkbox.
According to my understanding , i should first populate all the formnames and then for the currently selected user in the dropdownlist , i should extract all the formnames for that user.Now for each form name(extracted for the user) i should loop for 25 forms (because i have 25 forms i the gridview).
Am I proceeding in the right direction ?
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Best method would be to bind all the forms from "tblforms" table to the grid view. In grid view's RowDataBound event, query "tbluserdetails" table to find user has this form. If yes find the checkbox and check it.
|
|
|
|
|
i have another question.
The administrator is assigning the forms authorization to the user by clicking the checkbox parallel to the forms .
Now , I am going to tell you , the process of assigning the authorization to the user , which i implemented.
I select the form name which ever i have to assign to the user , then i click the save button , now lets say the user select ten forms, then i am iterating the gridview records , i mean putting each record into the loop , now the selected record will go into the database , the rest will be deleted.I mean if i have 25 forms , then iteration will take place 25 times.
Each record is being saved one by one in the loop.
Am i doing right ?
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
modified on Wednesday, February 20, 2008 6:07 AM
|
|
|
|
|
Yes it looks like. Alternatively you can create all insert statements and do a supply all at once which will be much faster as you are opening the connection only once.
|
|
|
|
|
in the user authorization table , there exists following fields
auto increment id
user id
formid
during the insertion the user id being fetched from dropdownlist
and the formod form the gridview
can u please elaborate the method u mentioned latter.
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
U mean SQL Bulk Copy ?
If it is that , then i need to create a teporary table which will have the userid and formid field.
because the user id lies in the dropdownlist and the formid lies in the gridview.
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
iam having a panel with a vertical scroll bar .in this panel there is a grid view now how i can view the last row of the grid view when a panel is clicked.
|
|
|
|
|
Hi All
I am working with one of project where i have to create a online test, the problem is how do i create timer in online line examination system, the timer should be a countdown timer, and exam should be ended automattically when the secified time in over
plz do the favourable reply
Yogesh Agarwal
|
|
|
|
|
Use javascript for timer control.
For details
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Hi
I have a strange problem
I have a button which has a cssclass in it and then in the stylesheet is where i specify the details for it.However it is having no affect on the button
below is the code:
<asp:Button CssClass="btcomp" ID="btspec" runat="server" OnClick="btspec_click" Text="Specification" />
.btcomp
{
background-color:#FFFFFF;
font-weight:bold;
width:200px;
height:500px;
}
any clues would be great
thanks
|
|
|
|
|
Are you sure that the stylesheet is linked to the page correctly?
|
|
|
|
|
sorted it, i needed to delete my cache for some reason
thanks
|
|
|
|
|
hi a-+s-+p-+,
Since you are applying CSS to Server side Control then either you are not specifying CSS class to style tag inside head as follows.
<head> <br />
<style type="text/css"> <br />
.btcomp<br />
{<br />
background-color:#FFFFFF;<br />
font-weight:bold;<br />
width:200px;<br />
height:500px;<br />
}<br />
</style> <br />
</head><br />
OR you are made separate CSS within the project but not linked CSS to page correctly as follows.
<link href="styles.css" rel="stylesheet" />
Hope this will solve your problem.
Thanks & Regards
Dilipv
|
|
|
|
|
Hello everyone,
I'm using ASP .NET 2.0 and I'm making a login page where I want to implement the remember me functionality such that that user be logged in the next time he comes incase he checked the remember me textbox. Now I've read in some articles over the web that you dont store the password in cookies coz it's potentially dangerous. so my question is how do we authenticate the user on the next time he logs in. Need a little guidance on this.
Thanks
Rocky
Success is a ladder which you can't climb with your hands in your pockets.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
