I'm starting in programming and ASP. So I'll begin to be a bother. My question is that I would like to show for example the name of a costumer from the SQLEXPRESS DDBB in a label. How do I do that, I imagine that you have to connect to the database and specify a row or something. But I don't know the code.
View 7 Replies
I am using aspnet menu control and i want to hide the item initially on page load and show the item after an event is trigger say button lick event Can any one give me an example?
View 6 RepliesI have 2 dropdownlist in my page
1-ddlzone1
2-ddlstore1
What I need is if I select default item i.e. 0 in Zone dropdown I need to show all items in store dropdown. Below is my stored procedure to get the stores
ALTER procedure [dbo].[selectcenter]
@RegionID varchar(5)
as
begin
select ID,Centername
from Shoppingcenter
where RegionID=@RegionID
group by ID,Centername
end
Below is House_info table in database
Id Behtop Service1 Service2 Service3 Name
1 1111 Ser1 Ser2 Ser3 Sara
2 2222 Ser4
I have lable=lblservice in my page that bind it from data base I want in lblservice show service1 and service2 and service3 column's data like below
ser1 , ser2 , ser3 so I wrote below code in SP
SUBSTRING (ISNULL([Service1]+','+' ',' ')+ISNULL([Service2]+','+' ',' ')+ISNULL([Service3]+','+' ',' ')+ISNULL(' ',' '),0,66)+'...'
as Service but here as you see in row with id=2 there isn't any data in service2 and service3 columns and just in service1 is data(ser4) so it show in lblservice data like below ser4, , , Â ...
but I want if in one of column doesn't be data it doesn't show (,) that come after data I mean I want if in 1 columns be data in show:
ser1,... NOT ==> Â ser1, , , ...
if in 2 columns be data shows
===>( ser1,ser2, ...) Â NOT ===>(ser1,ser2, , ...)
I bind dropdownlist in my page
protected void Page_Load(object sender, EventArgs e) {
BindDropDownList(DDL1, "city1", "name", "ID");
DDL1.Items.Insert(0, new ListItem("select city", "0"));
}
And SP
LTER procedure [dbo].[city1]
as
begin
select id,Name
from city
end
And design code
 <asp:DropDownList ID="DDL2" runat="server" CssClass="daddsd">
</asp:DropDownList>
And here is imagebutton code that when click on it update data into table
protected void ImageButton_Click1(object sender, ImageClickEventArgs e) {
string data = Server.UrlDecode(Request.QueryString["BehCode2"]);
SqlCommand _cmd = new SqlCommand("insertinfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[Code] ....
Here when i click on button it insert all data into table but it didn't insert my selected item from dropdownlist it insert select city that i define in page_load
 DDL1.Items.Insert(0, new ListItem("select city", "0"));
And when i delete this code from page load it insert in table first row of my table it didn't insert my selected item from dropdown list.
I'v been looking for ages on how to get the current selected menu item into a label. so for example on the menu you have home and about, if i click on about it will but the text "About" in the labels text whats in the body of the form. You could say its a sub heading and i would like to do this in c# ;) somthing like this:
lblHeading.Text = Menu1.Page.Title.ToString();
except this retutns the tabpage title not the actual menu item i selected.
i want to display value in textbox when a value is selected in listbox in webapplication vb.net.
Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersUserDocumentsDatabase4.accdb")
Dim cmd As New OleDbCommand()
cmd.Connection = con
con.Open()
cmd.CommandText = "Select ID,product from List"
' cmd.CommandText = CommandType.Text
Dim da As New OleDbDataAdapter(cmd)
[code]...
I use gridview and bind it from sesstion below is code below are code:
<asp:GridView runat="server" ID="GridView1" EmptyDataText="No orderPlaced !" CssClass="gridorder"
AutoGenerateColumns="false" DataKeyNames="Id">
<Columns>
<asp:BoundField DataField="Code" HeaderText="Code" />
<asp:TemplateField>
[Code] ....
Here in grid view I wand add
<asp:TemplateField> <ItemTemplate>
<asp:Label ID="Lblname" runat="server" Text="Label"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
And put databind value into Lblname
<asp:BoundField DataField="Code" HeaderText="Code" />
How I can do it?
I have a Datalist.In the ItemTemplate I add an asp:label and an image (img). I want both controls to be clickable as one Item so I put both inside a LinkButton.The result was strange I got only the Label clickable and fire the Datalist ItemCommand event ? how to make both works as one clickable Item ?
View 5 Repliesthese are my table in database
HOuse_p Table
Id
Behcode
Name
H_name
[Code]....
now in house.aspx page i have label
i want when users click item in index.aspx or click item from menubar in house.aspx (they bind from different table) Â in label show the name of item(related to users selected from index.aspx or house.aspx)
if they click item from  index.aspx it show name column from House_menu tabel .
and if they click on menu bar item in house.aspx in label show classification column data from House_p tableÂ
I've been trying to find a solution to my problem for about 2 days now, and have found nothing. I am new to .net and not really sure how to accomplish this. I have 4 tables in a database, Vendors, RepairCos, Cons, ConRepairHistory. What I'm trying to do is make a page called SendOutForRepair.aspx that has a insert item template where the first control is a dropdownlist that is attached to the Cons table (got this figured out) and is populated with the Serial Number field. I would like the selection from the dropdownlist to populate the 2nd control (VendorID) that is also from the Cons table....
View 1 Repliesim nearly finished with my new website, but im trying to get my images to show in a label. but it just wont show..
Can you guys see if im missing anything here?
Code:
lblwalloutput.Text += "<a href='Info.aspx?infoid=" + row["fldid"] + "' target='_Blank'>" + "<img style='border-size:1px; border-style:solid; border-color:white; margin:4px;' height='" + row["Picture_Height"] + "' width='" + row["Picture_Width"] + "' src='" + row["PictureURL"] + "' />" + "</a>";
It just displays blank squares.
In web config file I have add key values specified.
In the formview I have labels on edit , item and insert mode that I want to display all the time by getting those values from web config. I'm able to do that with no problem but when I change the modes between edit to insert or item view, I lose those label values until I hit the "select" twice from the Gridview, those values re-appear. Below is the snippet of the code. What do I need to do to retain the category values all the time?
[Code]....
[Code]....
[Code]....
[Code]....
<%@ Page Title="" Language="VB" MasterPageFile="secureds_deals.master" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<script runat="server">
Protected DealId As Integer = 0
Protected DealName As String
Protected StartDate As Date
Protected ContractDate As Date
Protected ClosingDate As Date
Protected SubmitRole As String
Protected Status As String.......
I am using gridview. I Added checkboc under itemtemplate.My page works fine. i have set my page according 508 standards. It looks for associated control id for every textbox, check box..etc.
When i check my page by 508 standards its giving form lable is missing for gridview item tamplate checkbox. i tried adding lable inside item tamplate and i set the check box id as Associated control id for the label. eventhough its not going off that error. After setting some text my errors are resolved.
but if add any text item template checkbox alignment is missing. i cann't hidden the lable. If i hidden the label it again show up Form label is missing. how can i add lable without effecting to GV item template checkbox alignment.
I want a labet to be visible if there is no records found when search the database.
here is the code and the code behind:
<asp:TextBox
ID="TextBox1"
runat="server"></asp:TextBox><asp:Button
ID="btnSokDB"
runat="server"
Text="Sk"
Height="22px"
OnClick="btnSokDB_Click"
/>
<asp:Label
ID="lblTilbakemeldingSok"
runat="server"
Text="Sket gav null treff. Prv igjen!"
Visible="False"></asp:Label>
[Code]....
how to show A1 textbox text and A2 textbox in a label ?
View 5 RepliesI am using a label named label1 and the following code for put an image in the label:
[Code]....
then for making the pic invisible in label I used the other button with the forecoming code
[Code]....
and it worked properly but I need to do the last job with one button click so I put those line of code together as follow:
[Code]....
I am having a label which I am creating through code. I want to populate this label through a function which returns me a DataTable. This DataTable has 1 row and 1 column in the return.This is my code:
Label1.??? = Repository.Instance.ReturnScore(ddlPlayer1.ToString(), ddlPlayer2.ToString());
ReturnScore is giving me the value as DataTable. How should I get the value in it?
I have a code to add item to dropdownlist but it shows the value only. I want an alternative text to appear for user. How to modify this code ?
DropDownList4.Items.Add(item:="%")
Now % is doing the job but I want the use to see the text "ALL" in the item of the dropdownlist.
I tried DropDownList4.Items.Add(item:="%,ALL") etc but failed.
On a line chart I want to show a data label at end with the final value.
I do not want to show the data label for the whole line, which happens if I choose show data labels.
how to set an access key for controls using the associated label but I can't figure out how to underline the appropriate letter so the users know which key to use.
View 4 RepliesOn my webpage i have labels showing data from database. Some values can have html tags in them, example <br>. When showing <br> in a Lable it converts it to next line. What do i need to do to make Label show <br> as "<br>" string?
View 1 RepliesI have a store procedure. I show the result in the grid view, I would like to know how I can show each fields in the label so I can place them anywhere that I like in the page.
This is my code:
using (SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
SqlCommand cmd = new SqlCommand("w_create_order", connection);
cmd.CommandType = CommandType.StoredProcedure;
//input parameters
cmd.Parameters.AddWithValue("@in_order_class", "WEB");
cmd.Parameters.AddWithValue("@in_owner_code", "OP");
cmd.Parameters.AddWithValue("@in_sales_campaign_code", "DEF");
cmd.Parameters.AddWithValue("@in_cus_key", null);
cmd.Parameters.AddWithValue("@in_lab_key", null);
cmd.Parameters.AddWithValue("@in_invoice_number", null);
connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
GridView1.DataSource = rdr;
GridView1.DataBind();
connection.Close();
I have label in page:
<asp:Label ID="Lblorder" runat="server" CssClass="lblorder1"></asp:Label>
that it will show session value:
if (Session["totalorder"] != null)
{
Lblorder.Text = Convert.ToString(Session["totalorder"]);
}
I want if there wasn't any data in session in tooltip of lable it will show "there isn't any order" ... How I can do it?Â
