Hi all. I have a label on my page and I want to bind it to a field in a table. The catch is that I want to bind it to the last row in the table. I think I can use the custom binding, but I don't know how to bind to the last row. Any Suggestions ?
p.s. The page is tied to an SqlDataSource that retrieves the data from the above table.
Thanks in advance.
I have a SQL database with 1 column in it.. it is a do not call registry for my office. I want to make a web application so our leads can go on the web and request to be put on the do not call list. problem is, if their number already exists, it gets a violation of primary key... Normal handling for this would be to do a select query based on user input, and if it exists in the database, tell them that, else do the insert query... Problem is, i cant seem to figure out how to bind the result of the select query to a textbox or label so i can compare the results to do that logic. Any ideas? This is in asp .net 2.0. Thanks! -Dan
View 5 Replies View RelatedHi,
Referring to the book "Data Mining with SQL Server 2005" written by ZhaoHui Tang, I created a Mining Structure and a Mining Model with the AMO API after creating Database and Data Access Objects(referred to code lists from 14-1 to 14-6). I added Nested Table by creating a table column and added a key column to the nested table, while the error showed that in my structure the column of the nested table didn't include effective data bindings when processing.
Thanks for any suggestion!
Hi,
I try to activate the map document control on my report. My Report is composed of a table in which I group by 2 criterias. When I set the document map label of the first entry of the group list then I get an error on the preview :
"An internal error occurred on the report server. See the error log for more details. "
Can someone tell where can I find the error log file ?
thanks in Advance.
I want to be able to have an authorized person set or change the default values of a table column in a SQL Database. I have a stored procedure that sets the default which works fine: ALTER PROCEDURE [dbo].[addMyConst]ASBEGINALTER TABLE [dbo].[tbl1]ADD DEFAULT 70 FOR [Auto_ourlim]END(I still need to put parameters in so that I can run the stored procedure from a form, but for now....)
To change it I know that I have to drop the constraint first like this:
ALTER PROCEDURE [dbo].[dropmyValue]ASALTER TABLE [dbo].[tbl1] DROP CONSTRAINT [Auto_ourlim]
The problem is that when I execute the procedure I get the error that "Auto_ourlim" is not a constraint so it does not drop the Default Value. When I go over to SQL Server Management Studio Express I can see why:
If I open up the table and open up the Constraints the constraint is "DF__tbl1__Auto_ourli__5FB337D6". I could change the DROP CONSTRAINT to this, and that works, but it changes every time I add the new DEFAULT VALUE. I don't know how to get around it. Is there a way to put wildcards around "Auto_our" in DROP CONSTRAINT [Auto_ourlim}? Any suggestions would be welcome...even if there's a totally different way to do it.
What I'm trying to ultimately accomplish is this: Column1 (AutoLimits) would be user insert to the database and then in the database it would MINUS Column2 (Auto_ourlim - set with the default value) = Column3 (Difference - a computed field in the database)
Steve
Hi,
I am new to .NET world. I am using visual studio express.
I am developing website using ASP.NET and C#.
I want to add buttons dynamically on a table row on my web page.
For this I have written this code in "example.aspx" file
<asp:Table ID="tblExample" GridLines="Both" BorderWidth="1" runat="server" >
</asp:Table>
In my corresponding "example.aspx.cs" file i have written
TableRow tr = new TableRow();
.....................
.....................
TableCell tc3 = new TableCell();
tc3.Width = 120;
Button bt = new Button();
bt.Text = btnStop.Text;
bt.Width = 120;
bt.CommandArgument = lrs.IpAddress + ":" + lrs.PortNo;
bt.Click += new EventHandler(cmdStop_Click);
tc3.Controls.Add(bt);
tr.Cells.Add(tc3);
tblExample.Rows.Add(tr);
In my EventHandler "cmdStop_Click" I am trying to perform some action but on that particular row's data.
My page is also reloading after every 5 secs.
After clicking a button in a row, when page refreshes, I am getting this message in popup error message. also that entry is ommited(as per code in EventHandler)
______________________________________________________
"The Page cannot be refreshed without resending the information.
Click retry to resend the information again.
or click Cancel to return to the page that you were trying to view"
resetButton cancelButton
_______________________________________________________
How to bind that button to particular row so that when I click on a button the action should be performed on that particular row's data.
Thanks
Hi,What's the 'new' declarative way to fetch one field from a SQL table and display the result in a Label control?I have a users table with a fullname field. I want to query the table and retrieve the fullname where the usertable.username = Session("loggedinuser")I can make the SqlDataSource ok that has the correct Select query, but not sure how to bind the label to that.thanks,Bruce
View 4 Replies View RelatedHi,
I have a little question. I have an application which interfaces with a SQL Express Database. On a form, I want to bind a control which is made of several Radio buttons to a table column which is in fact a varchar(1). This is the picture:
Table column: OptVisualRpt varchar(1)
Screen control: 2 radio buttons
rb_VisRPTbImp_O for "yes"
rb_VisRPTbImp_N for "no"
I'm really scratching my head as how I can bind a single table column to my radio buttons controls. I think that I just can't this way but rather have to use an intermediate variable or control.
Solution 1?
I thought of using a local variable that I would set to "y" or "n" following "CheckedChanged" events fired from radio buttons but I don't know how to bind this variable to my table column.
Solution 2?
I thought of placing a hidden text control into my form, which one would be binded to my table column, that I would also set to "y" or "n" following "CheckedChanged" events fired from radio buttons.
Any of these solutions which would be feasible or any more neat way to do it?
Many thanks in advance,
Stéphane
hi guys! help please..how will bind my texbox (TxtLastName) to my dataset (dsLastName) column (User_LastName). Thanks in avdance!
View 1 Replies View RelatedI've got SQL 2k5 on a Win2k3 box. I'm trying to find information or a how to on how to set up SQL to only respond to requests on a particular IP
Can anybody point me in the right direction or explain how?
v
i have to display some of my SQL data on a webpage, and i don't want to use the gridview and all his "friends". all i want is to display some values out of the sqlDataSource on my webpage.is it possible? and if so, then how can i do it?thanks in advance.
View 3 Replies View RelatedHello!
Is it possible to create a row of "labels" in a multi-value parameter list?
i mean something like this:
Name, Age
JJ, 12
PP, 10
Thanks
//C
I have a Report that has a document map Label in the Report which I need to remove.
However as the report has over 50 text-boxes I am having difficulty locating it.
I have had a look at the XML but that does not seem to indicate the offending text box.
Any advice would be greatly appreciated.
Regards
JohnJames
Hi all
I have a form view which uses a SQL data source control to retrieve it's data from the sql express database
the form view is used for view,edit,delete and insert data into the database
in the insert mode I have two dropdownlists, where the second one is depending on the first one to retrieve the correct data from the data base BUT
when selecting a value in the first dropdownlist it give me the following erro:
Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.
Please How can do this
any help is appriciated
bye
Hey guys, Am in need of help please, basically the program im working with at the moment is when you add a New Contract, it will grab the Contract Number you have entered, Post it over to another page, then using that number bind a Gridview. The SQL being "SELECT Contract_ID, Contract_Number, Start_Date, End_Date, Quarterly_Rent FROM ECS_Contracts_Test WHERE Contract_Number = " & conNoVar (this being the Contract Number of the recently added Contract), however then it comes to Bind the Grid it kicks up an System.Data.SqlClient.SqlException: Syntax error converting the nvarchar value
'2009P7899' to a column of data type int.But the Column Contract_Number is set to Varchar and all I really want to do is to create this gridview using this criteria and not convert anything! The Contract_ID is an int, which is needed as I increment it. Heres the error code: Public Sub BindtheGrid()'Bind the Contract Grid, where ContractID is used
Dim SQL As String = "Contract_ID, Contract_Number, Start_Date, End_Date, Quarterly_Rent"
Dim objConn As SqlConnection = New SqlConnection(ConnectionString)
Dim cmdstock As SqlCommand = New SqlCommand("SELECT " & SQL & " FROM ECS_Contracts_Test WHERE Contract_Number = " & contractQueryID, objConn)
cmdstock.CommandType = CommandType.Text
objConn.Open()
GridView1.DataSource = cmdstock.ExecuteReader()
GridView1.DataBind()
objConn.Close()
End Sub If you need any more information then please let me know. Mucho Aprreciated
Hi guys, I am about to bind my websites user inputted values into my database. I intend to use sql for this. THe site is very basic, dropdownlists and textboxes. The user is required to choose values and write in questions. Now these inputs ought to be stored somewhere right??, so for that i am using sql. Now i know sql, but how do I store data from a website and all, I have no clue, someone give me basic steps on how to go about doing this pleaseeeeee!!!
View 2 Replies View RelatedI have this stored procedure that almost works:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[udForumTopicMessageByForumTopicID]
@ForumTopicID int
AS
SELECT
ftm_parent.ForumTopicMessageID AS "ForumTopicMessageID",
ftm_parent.ForumTopicID AS "ForumTopicID",
ftm_parent.ContactID AS "ContactID",
ftm_parent.MessageTitle AS "MessageTitle",
ftm_parent.MessageText AS "MessageText",
ftm_parent.ApprovedInd AS "Approved",
ftm_parent.ReviewedInd AS "ReviewedInd",
ftm_parent.ParentMessageID AS "ParentMessageID",
ftm_parent.OwnerCompany AS "ForumTopicMessageOwnerCompany",
ftm_parent.CreateUser AS "ForumTopicMessageCreateUser",
ftm_parent.UpdateUser AS "ForumTopicMessageUpdateUser",
ftm_parent.CreateDate AS "ForumTopicMessageCreateDate",
ftm_parent.UpdateDate AS "ForumTopicMessageUpdateDate",
'('+CAST(ChildResponseCount As VARCHAR(10))+')' As "ChildResponseCount",
(T_Contact.Lastname + ', ' + T_Contact.Firstname) As "ContactName"
FROM [T_ForumTopicMessage] as ftm_parent
INNER JOIN [T_Contact] ON [T_Contact].ContactID = ftm_parent.ContactID
Left JOIN
(Select
COUNT([T_ForumTopicMessage].ForumTopicMessageID) As "ChildResponseCount",
MAX([T_ForumTopicMessage].ParentMessageID) AS "ParentMessageID"
FROM
[T_ForumTopicMessage]
WHERE [T_ForumTopicMessage].ParentMessageID = ftm_parent.ForumTopicMessageID
group by [T_ForumTopicMessage].ForumTopicMessageID)
as ftm_child ON ftm_parent.ForumTopicMessageID = ftm_child.ParentMessageID
WHERE ftm_parent.ForumTopicID = @ForumTopicID
ORDER BY ftm_parent.CreateDate
See the purple ftm_parent.ForumtopicMessageID. If I hard-code that to a 2, this works. With the fieldname there, SQL Server Management Studio says:
Msg 4104, Level 16, State 1, Procedure udForumTopicMessageByForumTopicID, Line 9
The multi-part identifier "ftm_parent.ForumTopicMessageID" could not be bound.
If any experts out there can help me out with this, I'm sure it wouldn't take much to fix.
I am building a web app with a sql db.
The data base is all fine.
I can display information from the db with a gridview from a sqldata source....all ok
What I cant seem to do, is tie a drop down list box with a,b,,c items to call the column
with the ..."all items starting with the letter a"
I have writen SELECT WHERE statement that (a%) which works fine at pulling what I want to the gridview
and displays it fine.
Does the gridview conect to the source..... and the drop dlbox connect to the grid
Or each have its own conection to the source........or drop conects to source and grid
conects to
You can see my dilema .
c# web dev
hi guys,
i want to count the number of times a particular data occurs in a table and display that data in a listbox
initially i planned to count the number of occurrences and bind that number to a variable for further manipulation but i have no idea how to do the binding part
how do i solve this?
thanx
Hi,Just a little question...Is it possible to link a SqlDataSource to a label without using a repeater or a formview?I just want to select one column from a single row in a single table and sending the value to a label.The code would be something like this :<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" SelectCommand="SELECT name FROM Page WHERE idPage = 1">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="idPage" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("name") %>'></asp:Label> So, what can I add in the label properties or in the codefile to make this work if it is possible ?Or am I obliged to "hard code" it in c# with an SqlConnection, a SqlCommand and a SqlDataReader ?Thanks in advance...
Hello!
I am trying
to select info from a database (MS-SQL) and show that whit a label. And don’t really
get every thing to work. So I am glad for that help I can get.
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = "data
source='XXX';User ID='XXX';Password=XXX;database='XXX'";
myConnection.Open();
SqlCommand dataCommand = new
SqlCommand();
dataCommand.Connection
= myConnection;
dataCommand.CommandText = "SELECT XXX,XXX FROM XXX";
SqlDataReader dataReader =
dataCommand.ExecuteReader();
string notis1 = dataReader;
Label1.Text = notis1;
myConnection.Close(); Any help whould be helpfoul.
A SQL Server 2005 stored procedure expects a parameter UserID depending upon which it retrieves the no. of records & OrderIDs corresponding to the UserID from a DB table (note that OrderID & UserID are two of the columns in the DB table). So for e.g. consider a user whose UserID=6 & the DB table has 3 records where UserID=6. In other words, there are 3 OrderID records of the user whose UserID=6, say, OrderID=8, OrderID=17 & OrderID=29. The stored procedure will finally return 2 columns - the OrderCount (which is 3 for UserID=6) & the OrderID (which will be 8, 17 & 29 for UserID=6). This is the stored procedure:ALTER PROCEDURE dbo.OrderCount @UserID intASDECLARE @OrderCount intSET @OrderCount = (SELECT COUNT(OrderID) FROM NETOrders WHERE UserID= @UserID)SELECT @OrderCount AS OrderCount, OrderIDFROMNETOrdersWHEREUserID = @UserIDIn a VB class file, I am invoking the stored procedure in a function named GetOrderCount which returns a SqlDataReader back to the calling ASPX page. I want the ASPX page to display the 3 OrderIDs of UserID=6 in a Label control. Unlike the DataBinding controls like DataList, DataGrid, Repeater controls, the Label control will not automatically loop through the recordset. So I tried to accomplish this using a For....Next loopDim i As IntegerDim sqlReader As SqlDataReaderiUserID = Request.Cookies("UserID").Value'ShopCart is the name of the class in the VB class fileboShopCart = New ShopCartsqlReader = boShopCart.GetOrderCount(iUserID)While (sqlReader.Read) If (sqlReader.GetValue(0) > 1) Then pnlLinks.Visible = True For i = 1 To sqlReader.GetValue(0) lblLinks.Text = sqlReader.GetValue(1)(i) Next i Else pnlLinks.Visible = False End IfEnd WhileBut this generates the following error:No default member found for type 'Integer'.pointing to the linelblLinks.Text = sqlReader.GetValue(1)(i)in the above shown ASPX code. Can someone please correct me & suggest how do I loop through the recordset so that I can display the records in a Label control?
View 8 Replies View RelatedThis is my SQLDataSource for my gridview
<asp:SQLDataSource ConnectionString="<%$ ConnectionStrings:Pubs %>" id="sqlProducts" Runat="Server" SelectCommand=' "Select * from adressen INNER JOIN Adressoort ON adressen.AD_ID = Adressoort.AD_ID where " & lblsql.Text ' ></asp:SQLDataSource>
the label is something like : adressoort.AD_soort = '3' or adressoort.AD_soort = '1'
I keep on getting the error sever tag not well formed
Hi all,I would like to do something I thought was simple but I can't seem to figure it out. I would like to bind the Text properties to two labels to the columns in an SqlDataSource, much the same as you can bind a listbox to a SqlDataSource.Is this possible?The reason why I'm trying it this way is because I originally used an OleDB connection and datareader, but it doesn't seem to work on our service providers server (keeps saying that it can't find the database) even though it works on the four other server's I've tried. It definitely connects to the database when I use the SqlDataSource on a listbox control, but it fails when I use the same connection string with the OleDB connection.Is this the best way to go about it, or should I persist with finding the OleDB/datareader (the service provider has been no help at all). Thanks.
View 1 Replies View Relatedhi,
i have this code it gets the records from db
i need to add the results of the datareader to a label but label control does not have a datasource property
second problem is how to comma separate the results.with array? or what please help
i need to show the results like this: record1,record2,record3Dim Conn As New SqlConnection(ConfigurationManager.ConnectionStrings("Conn").ConnectionString)
Dim strSQL As StringDim dr As SqlDataReader
Dim userID As Integer = Session("cmmLogonUserID")
strSQL = "select id,extension from musicExt"Dim cmd As New SqlCommand()cmd = New SqlCommand(strSQL, Conn)
Conn.Open()
dr = cmd.ExecuteReader()
'txtMediaFormats.Text = dr ???????
' ddlGenres.DataBind() ????????
Conn.Close()
Hi,
I have a sqldatasource which returns the result I want, but I need to assign it to a label or text box. Is there an easy way of doing this? I attempted it using this code:
PropertyFriendIDLabel.Text = PropUserIdSqlDataSource
Thanks
Here is my code. Basically what I am doing is selecting from the database based on the current user. The ReaderResults.Text label is not showing the info pulled from the database, and the ReaderError.Text label is not showing an error. I also tried putting the ReaderResults.Text label inside the loop and that didnt work. Any suggestions?
'Database ConnectionDim con As New SqlConnection("Data Source = .SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|ASPNETDB.mdf;user instance=true")Dim currentUserID
currentUserID = Context.User.Identity.Name.ToString()
Label1.Text = currentUserID
Dim selectSQL As String
selectSQL = "SELECT companyKey FROM Company WHERE UserID = ('" + currentUserID + "')"Dim cmd2 As New SqlCommand(selectSQL, con)
Dim reader As SqlDataReaderDim CompanyKey
Try
con.Open()
reader = cmd2.ExecuteReader()Do While reader.Read()
CompanyKey = reader("CompanyKey").ToString()
Loop
reader.Close()Catch err As Exception
ReaderError.Text = "Error selecting record."
ReaderError.Text &= err.Message
ReaderResults.Text = CompanyKey
Finally
con.Close()
End Try
The ReaderResults.Text is not returning a value. I am not sure what is going on because the table and all columns are full, Label1.Text shows the current username of the user loggedon, and no error is showing up in ReaderError.Text. Anyone have any ideas?
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Database ConnectionDim con As New SqlConnection("Data Source = .SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|ASPNETDB.mdf;user instance=true")
'Job1 InfoDim currentUserID
currentUserID = Context.User.Identity.Name.ToString()
Label1.Text = currentUserID
Dim selectSQL1 As String
selectSQL1 = "SELECT companyKey FROM Company WHERE UserID = ('" + currentUserID + "')"Dim cmd1 As New SqlCommand(selectSQL1, con)
Dim reader As SqlDataReaderDim CompanyKey
'Job1 Select
Try
con.Open()
reader = cmd1.ExecuteReader()Do While reader.Read()
CompanyKey = reader("CompanyKey").ToString()
Loop
reader.Close()Catch err As Exception
ReaderError.Text = "Error selecting record."
ReaderError.Text &= err.Message
ReaderResults.Text = CompanyKey
Finally
con.Close()
End Try
I have a simple column chart where the x axis is a week number, and the y axis is percent of sales. There are four charts on one page, so this chart is very small. There are only two bars on the chart, and I would like to have the value of the y axis, say 7.2%, be displayed on the bar itself. Currently, I can't decipher the exact value of each bar. Does anybody know if, and how, this can be accomplished? Thank you!
I have a long expression that returns the value of my one label. The expression is suppose to figure out if there are three parts to the MailAddress field and return the appriopriate number of fields properly formated. The format I need to get returned from this delimited field looks like
PersonIdNumber
CO Line
Name Here
123 Address Street
City State Zip Country
Each line is followed by a semicolon which I have coded to each be replaced by a newline. The main problem is that sometimes we have a CO Line and sometimes we don't. There will be a delimeter right before the AddressStreet Line even if the CO Line does not exist, so that shouldn't be a problem.
Also, the Name Here line is not returned from my delimited MailAddress field, it is a seperate field. For some reason the label returns an error in the report. I'm assuming it is it is in the code below. If you see something wrong with the expression please let me know.
Code Snippet
=IIF(Count(Split(Fields!MailingAddress.Value, ";")) = 3, (LTrim(Replace(Replace(Choose(1, Split(Fields!MailingAddress.Value, ",")),",", " "), ";", " "))& vbcrlf & Fields!Name.Value & vbcrlf & LTrim(Choose(2, Split(Replace(Replace(Fields!MailingAddress.Value, ";", vbcrlf), ",", " "), vbcrlf)))& vbcrlf & LTrim(Choose(3, Split(Replace(Replace(Fields!MailingAddress.Value, ";", vbcrlf), ",", " "), vbcrlf)))), (Fields!Name.Value & vbcrlf & LTrim(Choose(1, Split(Replace(Replace(Fields!MailingAddress.Value, ";", vbcrlf), ",", " "), vbcrlf)))& vbcrlf & LTrim(Choose(2, Split(Replace(Replace(Fields!MailingAddress.Value, ";", vbcrlf), ",", " "), vbcrlf)))))
I'm currently using SSRS 2005...
Hi all,
In Table Detail session,
=Fields!test.Value
Will popup as numbers. 1 2 3 4 etc.
I set parameter as Value 1 = Label "First" Value 2 = Label "Second"
Is that possible to show the lable of Fields that I set in Parameter?
Advice plz.
Thank you
Hi, i am a newbie to reporting services.
Am trying to create a mailing label report so that it can pull out the details from the database and gets printed onto the label stickers correctly. However, no matter how i adjust the sizes of the report from the page properties, it's still not printed properly.
I have 7 label stickers on 1 mailing page, so let's say i have 13 records, that will be 2 mailing pages. Each label sticker is about 9cm width by 3.6 cm height. The gap between each label sticker is 0.2 cm
Can anyone advise me on how to go about doing it? By the way, i am using SSRS 2000.
Any help is appreciated. Thanks :)
i am once again working with mailing labels. I have designed the report in SQL Server Reporting Services to print in 3 columns with a body size of 2.625" wide by 1.00" high; a rectangle the same size which then contains a list the same size which contains the data fields. I get fairly good results when I print to one printer however, there does seem to be a bit of "creep" on the page. The problem really shows when trying to print to another network printer where when a user prints the report (labels) by the end of the page data is printing outside of the label margins. are there some properties that I'm missing that would prevent this or could this be related to printer settings?
View 4 Replies View Related