I've got a repeater on my asp.net (VB):
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("Question_Number") %>' />
<%#Eval("Question_Desc")%>
Now what I want to do is, check a value that I haven't used called "Question_Type" which could be = 1, 2 or 3 depending if it is multiple choice, short answer, etc. I have tried this:
<%
if Eval("Question_type") = 1 then
Response.Write(" <asp:RadioButton runat=""server"">test1</asp:RadioButton>")
Response.Write(" <asp:RadioButton runat=""server"">test2</asp:RadioButton>")
Response.Write(" <asp:RadioButton runat=""server"">test3</asp:RadioButton>")
end if
%>
and I get this error: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. HOW can I use this value in a if statement?
vote-up@{puzzle.UserVote .... is not treating the @ symbol as a start of a code block @puzzle.UserVote == VoteType.Up looks at the first part @puzzle.UserVote as if it's supposed to render the value of the variable.
This is the code i have used to get LocationID from database with MerchantID. I am getting an exception from Fill dataset part. The error is Error converting data type varchar to bigint.
public DataSet getLocationID(long MerchantID) { //long LOCID = null; try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@merchantID",MerchantID) }; string strCommandText = "Select LocationID from Merchant_Location where MerchantID ='@merchantID' order by LocationID ASC"; Debug.WriteLine(strCommandText); DataSet pds = new DataSet(); SqlHelper.FillDataset(DbConnString, System.Data.CommandType.Text, strCommandText, pds, new string[] { "LocID" }, parameters); return pds; } catch (Exception ex) { //LogError("Error Occurred When Retrieving LocationID: " + MerchantID.ToString(), ex); return null; } }
I am facing an intresting problem now with entity framework. if i did a count of the some table with linq statement its give some count and it is not matching with my normal sql query count. my sql query returning count of all the records in that table where as linq query returns some count which is less than sql count. is this a problem with my edmx or table navigation properties..i do have some 5 to 6 child tables inside this table with foreignkey relation. will it do a join on each child table and returns only those records. I am very much confused and don't know how to slove this.
I'm using the 'Configure Data Source' wizard to connect to my database and show the dataset in Gridview. I want to be able to update, insert and delete entries but am unsure how to build the query. I can write simple update statments to change database entries but how can I do this for entries that have been changed within the gridview?
I have a gridview, and I set the datasource in page_load to a linq query. I have delete linkbutton in the grid and am writing code in gridview1_rowdeleting event to delete the record from the table and all its records in child tables. Works fine, except when I databind() after the deletes to refresh the grid, it thinks there are no records left in the table and goes to the <emptytemplate> . There are in fact many other records that should appear. When I go out of the gridview and come back in, everything is fine. The proper records have all been deleted, and the remaining ones show. Here is the code. the table being displayed is Schedule. It has child records in the two other tables.
i'm opening a new window and passing on to it variables in a querystring, the values are loaded into a function that is filling my dataset and then filling my Gridview. after i press the button field in my grid to delete an item, the databind doesn't show the updated grid but remains the same. i've noticed that if i navigate back and refresh i see it correctly. in FF btw no problem.
etc., which is placed inside of an ItemTemplate inside of a TemplateColumn. In the CodeBehind page I will bind a value to the OrderXml field, which occasionally is NULL.
string sqlstring = "SELECT DISTINCT STAFF_ID, SCHOOL_CODE FROM MODULE_TIMETABLE_STAFF WHERE STAFF_ID != '" +userId + "' AND STAFF_ID LIKE '%" + Searcht + "%' ORDER BY STAFF_ID ASC";
can anyone explain this statement for me? especiallythese signs !=,+ +
I want to add Sum contents from the two tables, Realize the rows could be different, Only like rows to be added rest of the rows from both tables are listed.
SELECT TYPE AS CashFlow, Sum(AceData.InCredit) AS Credit, Sum(AceData.OutDebit) AS Debit, Sum([InCredit]+[OutDebit]) AS Totals FROM AceData where case=1 GROUP BY Type; CashFlow Credit Debit Totals Advert $0.00 ($5,816.52) ($5,816.52) BOND $0.00 ($3,060.00) ($3,060.00) Cash $18,619.57 ($34,824.75) ($16,205.18) Charity $0.00 ($6,578.00) ($6,578.00) DayCare $0.00 ($2,360.00) ($2,360.00) SELECT TYPE AS CashFlow, Sum(AceData.InCredit) AS Credit, Sum(AceData.OutDebit) AS Debit, Sum([InCredit]+[OutDebit]) AS Totals FROM AceData where case=2 GROUP BY Type; CashFlow Credit Debit Totals BOND $0.00 ($3,060.00) ($3,060.00) Cash $18,619.57 ($34,824.75) ($16,205.18) Charity $0.00 ($6,578.00) ($6,578.00) DayCare $0.00 ($2,360.00) ($2,360.00) Entertainmen $0.00 ($12,258.18) ($12,258.18) Equipment $0.00 ($7,085.00) ($7,085.00) Fee $1,957.63 ($27,611.85) ($25,654.22)
How can I schedule several statements that involve select ... into ..., delete, and exec one other stored proc, periodically? For instance, every 6 hours, in Sql server DB
I'm using MySql in my asp.net project. But I don't want to type every "using MySql.Data.MySqlClient;" statement in every aspx.cs/aspx.vb file. How can I define this lines in web.config file?
I've defined some namespaces like below but this only works for aspx pages:
how to join 2 sql select statements in Oracle, which has different number of rows. That is I have first select statement which fetchs around 80 records in below format.
Second statement will give reocrds like below. That is it will give only distinct dates. Please tell me how to join these two queries. So that I can get
DATE Rank 12-01-2010 a 12-02-2010 b 12-03-2010 c
how to join these two queries. So that I can get result set in below format.
DATE MONEY Rank 12-01-2010 10 a 12-01-2010 15 a 12-01-2010 15 a 12-02-2010 15 b 12-02-2010 15 b 12-03-2010 15 c 12-03-2010 15 c
I have a ListView with many advanced controls and html tags. ListView is bound to collection of profiles when first profile in collection is current profile. current profile has few differences from other profiles ie. flash embed, js and some other stuff. I can access inside of my ListView Container.DataIndex property which gives me 0 as first item in index but i'm unable to use inline If statements like so
<% If Container.DataIndex = 0 Then %> do stuff <% EndIf %>
this is because i must place pound to access databound item but neither this
<%# If Container.DataIndex = 0 Then %> do stuff <% EndIf %>
The @( ) syntax enables a code block to have multiple tokens. For example, we could re-write the above code to concatenate a string and the number together within a @( code ) block
The website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
