How should i write an sql statement in an SqlDataSource control?
<% String inuser="john";%>
<asp:SqlDataSource ID="SqlDataSource1"
runat="server"
ConnectionString="..."
SelectCommand="select from users where user='<%#inuser%>'??????????????" DeleteCommand="..." InsertCommand="..."
UpdateCommand="...">
</asp:SqlDataSource>
I have the following code to For each Item in the file uploader, Insert Into database.... but It doesnt work in the For Each Statement but if i take it out of the For Each statement it works.
For Each item As AttachmentItem In Attachments1.Items
Dim objConn2 As New SqlConnection("Data Source=XXX")
objConn2.Open()
Dim objCmd2 As New SqlCommand("INSERT INTO clientport (name, event, date1, username, password, path)" & "VALUES (@name, @event, @date1, @username, @password, @path)", objConn2)
objCmd2.Parameters.AddWithValue("@name", clientname.Text)
objCmd2.Parameters.AddWithValue("@event", [event].Text)
objCmd2.Parameters.AddWithValue("@date1", [date].Text)
objCmd2.Parameters.AddWithValue("@username", username.Text)
objCmd2.Parameters.AddWithValue("@password", password.Text)
objCmd2.Parameters.AddWithValue("@path", item.FileName)
objCmd2.ExecuteNonQuery()
objConn2.Close()
My application includes BUILDING table with columns BUILDING_ID, NAME, TOWN_ID, I run the LINQ query listed below and need to append two letters to buildings.NAME based on TOWN_ID. I assume that I need to place an "if" or "select" statement inside the query but I can not figure out how to do that,
[Code]....
I'm trying to display an image inside a ListView control based on the value of a databound property. I've tried two methods of doing this (one at a time) and both returned errors of "The server tag is not well formed". Consider the code below.
<ItemTemplate>
<div class="left">
<!-- Method 1 -->
<img src="media-play-button.png" alt="Play" class="mediaplay noborder" runat="server" visible="<%# Eval("MediaType").ToString() == "video" %>" />
<!-- Method 2 -->.........
I have the following statement:
List<string> tracks = new List<string> { "ABC", "DEF" };
var items = (from i in Agenda.AgendaSessions
select i).Where(p => p.Tracks.Any(s => tracks.Contains(s.Code)));
this returns all sessions which track contains either ABC or DEF, now when I rewrite the statement like the following, it returns All sessions regardless, as if the clause always yeilds into true,
var items = from i in Agenda.AgendaSessions
where i.Tracks.Any(s=> tracks.Contains(s.Code))
select i;
Update
if there are other clauses within the where, does that affect the results?
is there a way that I can format a Date binded in a ListView?I have this snippet of ListView
[code]...
What I want is to Format that date to output something like this Oct. 20, 2010. Normally if it is a DateTime I can write something like this requiredDate.ToString("MMMM dd, yyyy") but inside the ListView binded data I cannot do that.I don't want to use OnItemDatabound. I just want it to be formatted inline.
In my application I have panel which has 5 textboxes. I've written several functions for checking each of textbox if the entered value is ok (number, is this number in database, etc.). If error occurrs textbox which caused it has different color of background.
However I wanted to write (add) function which will check if one of the textboxes has the same value as other. The problem is that function is checking blank textboxes, although it shouldn't - I wrote if statement which allows checking only non-blank textboxes but it doesn't work.
I have a datagrid that populates correctly and a drop down list.
I have a table with (below) and it popluates a drop down and works properly.
UploadFile -- UploadFileTypeID
-Select 0
Images 1
Spreadsheets 2
Documents 3
Inside the datagrid sort command I want an IF statement. But the IF statement I have now doesn't recoginze whats inside the SQL table ( == "Images").
I have this...
[Code]....
From my understanding this if (ddl_Upload.SelectedValue == .... Is only recognized if I would have listed -Select, Images etc as List Items for the drop down?
i have the code to test:
Cmd = New OleDbCommand("update TabEntrevistado set EntrevistadoConcluido=true where EntrevistadoCodigo =8", Con)
Now, I need something like this:
Cmd = New OleDbCommand("update TabEntrevistado set EntrevistadoConcluido=true where EntrevistadoCodigo =" + LblInfoEditar.text, Con)
The problem:
The LblInfoEditar is outside the datalist so it works fine. (note: in this label I put a value like the 8)
But I have this label to test because I need to access a label inside datalist:
<asp:Label Visible="false" runat="server" ID="LblNumEntrevista" Text='<%# Container.DataItem("EntrevistadoCodigo") %>'></asp:Label>
The problem is: in this line I've to put something to access this LblNumEntrevista HOW?
I try:
Cmd = New OleDbCommand("update TabEntrevistado set EntrevistadoConcluido=true where EntrevistadoCodigo =" +
ListaPendentes.LblInfoEditar.text, Con)
But of course I don't work because I can't do this...
I'm creating a web user control and want to get some html from a datasource and write it to the page. I initially though I should just use response.write, but the problem with that is it writes the message above everything in the page the user control lives in - I guess because the uc is built before the page.
View 1 Repliesi am doing a webapplication where any asp.net control i am using is not available while i am writing code in code behind. e.g- i am using a DataList but i did not find DataList1 in the pop up to show my data in .cs page. i dont know what is the problem .
i am using Visual Studio 2008 pro SP1.
I'm trying to test the login control without writing any code. According to Murachs book, you can drag and drop the login control onto a Login.aspx form. Use the ASP Configuration Security tool to create user, roles, and access rules for the website. And you should then be prompted for authentication. I created two folders in my website, admin and users. The admin folder has a admin.aspx form and the users folder has a users.aspx form. I also edited the access rules to only allow admin to access the admin.aspx and only allow user to access the users.aspx form.
View 4 Repliespublic class OneControl
{
...
public OneControl Content(Action value) {
ContentProperty = value;
return this;
}
public void Render()
{
ContentProperty();
}
...
}
Then I got this in my view :
<div id="pleaseHelpMe">
<% OneControlInstance.Content(() => { %>
Some Mixed Stuff <%= Example%> Euros
<% }).Render() %>
</div>
I would like to use this syntax in my UI library, I know how to implement this but I don't know HOW it actually works! I understand that somewhere and somewhat a delegate is created and provided as an argument of the method Content, but can't find any information about this mecanism or technic. Assumed current correct answer : The compiler translates the aspx code below into (symbolic translation for comprehension):
<div id="pleaseHelpMe">
<% OneControlInstance.Content(() => {
ViewPageInstance.Response.Write("Some Mixed Stuff ");
ViewPageInstance.Response.Write(Example);
ViewPageInstance.Response.Write(" Euros");
}).Render() %>
</div>
I've created a multiple uploadfile user control - upload_multiple_files.ascx:
[Code]....
which has an update panel ID = up_upload_multiple_files this user control will be placed inside a modalpopupextender. My question is when I click in any button AddFile, RemvFile, Upload there's a postback so the page is reloaded and the modalpopupextender disapears Is there a way to to troubleshoot this?
Hello all i have this little issue getting this to work, i have a dropdownlist in asp.net inside a formview and jquery cant find the control im guessing because its inside a form, this is what i got and it works on another page without a formviewi get this errorName 'Country' is not declared
[Code]....
I have a ObjectDataSource and a ListView referencing it.
I have created a Templated User Control (see:
http://msdn.microsoft.com/en-us/library/36574bf6.aspx) and placed it in the ListView's InsertItemTemplate
It has one template <ContentTemplate>. Inside that template, I've defined a couple of server controls with their properties = '<%# Bind("colName") #>'.
See below:
[Code]......
I have a listview control on an .aspx page. Inside this list view i want to check "Type" property which comes from database. here is the example code :
[code]...
As a last resort i tried to user DataBinder.Eval() but i get the exception "Expected class, delegate, enum, interface, or struct". What can i be doing wrong? Writing a function in code-behind isn't an option for me.
I've got a form view that gets it's data from an access database:
I need to make the text of a label display Correct if the contents of the database field is 1 and Incorrect if it is 0
I was hoping I could turn the label's value to a string
(like this: <asp:Label ID="RightWrongLabel" runat="server" Text='<%# Eval("RightWrong").ToString() %>'/>)
and then access it in code view and write an if statement, but when I try to access the string in codebehind it says it's not available in the current context.
i have two tables named
1.LookupPageInfo and (LookupPageInfoId,pathmessageID,pagemessageID)
2.Messages (MessageId,MessageText,ChannelID)
Now i need to write a query something like this........in the query i need to pass the pathmessageid and needs to get messagetext from Messages Table,i am not sure how i need to write the below query..can someone guide me how can i write a query......as below..
select LookupPageInfoId,
PathMessageID,
pagemessageID,
(select messagetext from Messages where MessageID=PathmessageId) as TEXT from LookupPageInfo
I know it is recommended to use a using statement with a sqldatareader, but I was wondering if it is necessary when you are setting the datasource of a control to a datasource directly. in some places in my code I do this.
using (SqlDataReader reader = getReader())
{
while (reader.Read())
{
// do stuff with data
}
}
when binding to a control I do this.
ddlCustomer.DataSource = getReader(); // get Reader returns a sqldataReader
ddlCustomer.DataBind();
In the second case, do I need to use a using statement. Do i have to first declare an SqlDataReader in a using statement, then set the DataSource to that object. Seems like more clutter in the code, so i was hoping binding to the SqlDataReader disploses of the SqlDataReader.
i have a calender control like this
<asp:Calendar ID="CldrDemo" runat="server" BackColor="#FFFFCC" BorderColor="#FFCC66"
OnSelectionChanged="CldrDemo_SelectionChanged" OnDayRender="CldrDemo_DayRender">
</asp:Calendar> [code].....
i want to call the event handler for the dropdownlist - selectedIndexchanged and i have added it also like this
protected void ddlBlist_SelectedIndexChanged(object sender, EventArgs e)
{
}
but this is not getting fire when i am changing the item of the dropdownlist.
I am pulling states from a database. When I get to "district of columbia" I would like to change the result to "washingtondc".
Can this be done from within the contol? A basic IF THEN? How do I go about it?
I hope I have the right forum =)
Here is the issue.
I have a table:
[URL]
What I would like to do is retrieve the Grade score based on a number that is between the Max and Min for that Job Title.
I presume the sql would be like:
"SELECT [Grade] FROM [NUGGET_Tech_Score] WHERE ([Job_Title] = @Job_Title AND @total BETWEEN [MinScore] and [MaxScore])"
However since I am new at this, I am not sure how to get the grade and show it as a label on my form.
Should I be using a Form View control instead of the SQL statement?
I'm a little stuck here, with my first server control. I'll just post the whole thing, as I'm sure I've done plenty of mistakes. The main thing for me to find out is if there's a more elegang way to write this.
What I'm trying to accomplish here is to write a panel with custom HTML inside it. Inside the custom HTML, I need to put some server controls I can actually reach. My attempt at finding the span in the code failed, so there's obviously something wrong.
[Code]....
Obviously, I've only just begun, but I'd really value some feedback before I dig myself in too deep ;)
I am using Listview to display the data. for a real estate website,
the problem is when the property is for sale I need to show price of sale Asking_Price or when it is for Rent i should display the Rent Amount Rent_amount field and when it's for sale and for rent i want to showboth records.
[Code]....