i am using asp.net and in my .aspx page i have below code and based on the selection i am displaying the divs and which works great. but the question is: how do i get the value (whatever selected by user) on code-behind?
<select id="filterResultsBy" >
<option value="">Select...</option>
<option value="Date">Date</option>
[code]...
Can the select command of a SqlDataSource be given by code in the code behind file. Also by calling the SqlDataSource.Select can the select statement be executed?
View 3 RepliesSELECT * FROM tblstock WHERE Devicestatus=('Active') AND Model like '%"&criteria &"%'The statement above is a snippit from my code. My problem is that the search won't understand a space between say two words.?so if the user puts in DELL COMPUTER it won't return anything!? But if they put in DELL on its own it finds the record that says DELL COMPUTER?!!I'm just a bit confused that's all...
View 6 RepliesI have two databound listboxes. The first only shows items that have been assigned to my product. The second listbox shows all available items. What I want to do is select all of the items in listbox 2 that list box one contains.
For example:
ListBox1-
Item 1
Item 3
ListBox2-
Item 1 (Selected)
Item 2
Item 3 (Selected)
Code I have:
List<string> myList = new List<string>();
foreach(ListItem f in ListBoxSourceDetail.Items)
{
myList.Add(f.Value);
}
myList.ForEach(delegate(string n)
{
ListBoxSourceEdit.SelectedValue = n;
});
I use html Select in apsx page and bind it to data in database as dropdown:
<SELECT id="dd" name="dd" runat="server" DataValueField="ID" DataTextField="Name">
Then in code behind, I can get the selected item value(which is mapped to ID) as:
myvalue = dd.value;
But I want to get the selected text(which is mapped to Name), not the value in code behind. How to do it?
how to fix my sql syntax so my code works again, i made a few manual entrys for now to see if I can get them to be displayed: The FriendUserID relates to another UserID in the usertable who has obviously a different picture and information but I dont know how to display to concurrent WallPosting's from different users atm.
my code creates a dynamic div gives the div an ID = to the userid and input the wallpost messgaes named wallpostings, it takes the information stored about the userid and applys the image related to that userid, is there any way this can be changed with sql? or have i went down a one way alley?
public partial class UserProfileWall : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
//It is a postback so check if it was by div click (NOT WORKING because the javascript isnt posting back)
string target = Request["__EVENTTARGET"];
if (target == "DivClicked")
{
string id = Request["__EVENTARGUMENT"];
//Call my delete function passing record id
using (OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=gymwebsite2; User=root; Password=commando;"))
{
cn.Open();
using (OdbcCommand cmd = new OdbcCommand("DELETE FROM WallPosting WHERE idWallPosting="+id, cn))
{
cmd.ExecuteNonQuery();
}..............
I would like to select one of the rows of a gridview by default, when the gridview is first created (on databound?).
I know the SelectedValue that I want to select. How can I select that row, i.e. set it as Selected and show it with the SelectedRowStyle, etc.
I see that GridView1.SelectedValue is read only.
I have a problem. How to select a GridView row from code behind and get events fired?
View 3 RepliesI have a list of users that's coming from a web service, each user must be assigned a job as they come in, in a round robin method,
example:
users 1 2 and 3
next it's users 2 3 and back to 1
and so on.
My problem is the list has the abilty to change. Could someone point me in the correct direction, C#, VB does not matter?! Article or Code Snipet
I have a grid view with select button in cell[0], a column "comp_name" in cell[2], a textbox and a search button beside it.
I want when I enter a company name in a textbox and click on search button a row contains this company name is being selected.
I have SQLDataSource for my gridview. By default it works fine but i need to determine a few things before calling my procedure. By this i mean i need to determine a few things about the fields completed and set a flag to determine where the procedure will look.
I found a few examples online on passing parameters in code behind, but cant seem to get them to work. Here is what i tried and cant get results back. When i execute the procedure on the SQL side with the same parameter values, it works, so i know its returning results, so means my values are not being sent or im doing something really wrong. I have some of the lines commented out so the page can load and display for now.. but i need to get it working with custom parameters and flags.
Here is my SQLDataSource:
[Code]....
[Code]....
I have a need to add my page controls dynamically in code behind.
I do well, adding a dropdownlist, a SQL datasource to populate it, setting it to autopostback=true, and adding a gridview and its SQL datasource.
What I'm unsure about is how to programmatically refer to the SelectParameter, being a control (the DropDownList), and its selected item.
i have a gridview with one column as commandfield-select. now where and how to code the select ? i mean to make an action when this 'select' commandfield is clicked?
View 8 RepliesI want delete, edit, select items is in grid view i have to do in c# code it will reflect to database also
View 3 Replies I am using the following code to select data which appears between 2 dates:
string query = "SELECT (name, date) FROM date where tableinfo
BETWEEN @date1 AND date2";[code]....
Now the above code is working fine. The only problem is that the date in the date column of the gridview is not in the proper format. What can i do in order to change the format of the date in the gridview. If the format of the date is changed in the databse itself I may be able to use the above SQL query.
The drop down list is used to determine what search criteria will be used to find an invoice. I tried to set the Select method in the switch statement. I don't understand how to set the Select Method and the select parameters programmatically though . I tried a few different ways but can't make the compiler happy. My ODS is in scope in the code behind. I'm not able to access it's properties though. The BAL resides in a separate project that is a ClassLibrary. I also have a using statement for the ClassLibrary project in the code behind.
give me an example of how to do this?
Mark up:
[Code]....
[Code]....
[Code]....
[Code]....
protected void Button19_Click(object sender, EventArgs e)
{
SqlDataSource conn = new SqlDataSource();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["Database2ConnectionString1"].ToString();
conn.SelectCommandType = SqlDataSourceCommandType.Text;
conn.SelectCommand = "SELECT FROM table1 (a, b)VALUES(@a,@b)";
conn.SelectParameters.Add("a",TextBox1.Text);
conn.SelectParameters.Add("b", TextBox2.Text);
int rowsAffected = 0;
try
{
rowsAffected = conn.Selectt();
}
catch (Exception)
{
Label1.Text = "Error";
}
finally {
conn = null;
}
if (rowsAffected != 0)
{
Label1.Text = "Data saved";
}
}
well it returns error no overloading method for select (P.S. same code work fine for insert)
Can any one let me know about the below issue. I have a page which has three labels, say startdate,enddate and username. My issue is if the user doesnot select any of the above three then a message gets displayed as "Please select one search criteria" or if the user doesnot enter the date in correct format then i dispaly "Please enter date in mm/dd/yy" format. But what is happening is first time if the user doesnot select any then "Please select one search criteria" is getting displayed and after this message gets displayed if the user enters wrong format of date then both the messages are displayed.
View 5 RepliesI will declarate a attribute, but it gives me an error
This query works fine and returns 1 record from type int:
SELECT TOP 1 DataObjectVersionID
FROM tblDataObjectVersionPropertyValueText
WHERE PropValue like CAST('00010281' AS ntext)
ORDER BY DataObjectVersionID DESC
And when I will declarate a attribute/parameter it gives me an error:
DECLARE @dataObjectVersionId INT
SET @dataObjectVersionId = SELECT TOP 1 DataObjectVersionID
FROM tblDataObjectVersionPropertyValueText
WHERE PropValue like CAST('00010281' AS ntext)
ORDER BY DataObjectVersionID DESC
Error message:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'SELECT'.
i'm trying to to create a simple string array with data retrieved from a select statement(SELECT firstname FROM customers , for ex.)
View 6 RepliesI have gridview. some columns are data, and some are link buttons. now, I need move these link buttons to a hovermenu. this is done. but I got a javascript exception, and it is because if there is no row was selected in gridview, it will pop this.
so, the question is: how can I select a row in gridview without select command? simply by code?
Is there any way to do this? I can't find anything to latch on to.
View 2 RepliesHow would i make a select statement select the row with the nearest values? e.g.: I have 3 labels, labels1 2 and 3, with values of 1.2, 2 and 5.8 In my table i have 4 columns, first is the data im after, and the next 3 relate to the three labels. I want to select one row, where the values of labels match it the closest.......
View 8 RepliesI am trying to write a stored procedure that takes out a list of blog entries from a table (tblFeedEntry) as well as the amount of comments that each blog entry has gotten (tblFeedComments) but all I can get is the total amount of comments of all blog entries together, displayed on all entries. This is how my code looks today:
[Code]....
I am guessing that the problem is that the declared variable is not picking up the id of the blog entries, instead it picks up everything. The original select and the select in the declared variable are not connected. How do I connect them?
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