I have stored checkbox items in the database where Yes = "1" and No = "0".
If I want to retrieve them again (from database) as checkbox items on a page, how do I go about this?
I have been able to save an image in the database but i can not preview it
View 4 Repliesi am looking for a very simple way to display images on my form by retrieving them form sql database, by chosing their IDs.
View 8 Repliesi have web application it should create single HTML page . that one HTML page should send to the customers.how to create HTML page .i created one page but it retriveing single record from the databse values . my problem is i have to pull all the records from the database and papulate the HTML page. but i am getting only onerecord on that page.my code as follows
string type = ds.Tables[0].Rows[i].ItemArray[4].ToString();
string WAIVN = ds.Tables[0].Rows[i].ItemArray[0].ToString();
string status = "cdcr";
[code]....
but iam not getting all records only single record only iam retriving
I have a search option which a person can use a multi select listbox. I have it coded so it would loop through to see if its selected or not. I also have a stored procedure where the sql statement is coded for the select statement. For some reason, its not populating my gridview. Where am I doing wrong? Below is the code and stored procedure.
[Code]....
[Code]....
I am somewhat new at C# so forgive me if I have something listed wrong. This is what I got:
I am working on a school project designing a car dealership website. I have an inventory list that allows you to edit any car in the inventory. When you click on the edit button it takes you to the edit page and populates the controls with selections from the database. I have an options table that stores the VehicleID and Option ID. When the page loads it fills all the DropDownLists for the vehicle info with the data and selects the correct item according to the database selection but the CheckBoxList does not select the items that are on the Options table. I checked the query in SSMS and it returns the correct data. I have stepped through the method and it works till the "(currentCheckBox != null) if statement. It doesn't throw any errors but it also doesn't select items when the page renders.
I thought it might have been something with the page life cycle since databound controls don't render until the end but the DropDown's I have fill and selects the correct item according to the database.
On my webpage, jobs.aspx, I have a gridview which is populated from my database. I would like it so that when a row in the gridview is clicked, the ID of the row from my database can then be passed through as a query string to a second webpage, details.aspx, where more information about what was clicked on will be displayed.
I'm confident about being able to pass the query string, I just need help with getting the corresponding row's data ID from my database and making the gridview click-able, which will be the interaction which specifies which ID to be retrieved.
I have menu list like this
and I want to fill it's Items from my SQL database, is that possible ?
Is linq just for retrieving data or can you send data to the database using it?
View 3 Replieshow to add listbox items to database ..all items without selecting any particular...
View 1 RepliesI have a page which will retrieve data base on drop down lists and place the data onto a gridview. When the data was entered, each field was entered with multi-selected and delmited by a comma. In the database, some fields will have a string with multi information delmited by the comma, for example, Chicago, Atlanta, NYC will be recorded and place in the field in the database. I'm trying to search now but with a dropdown list with Chicago, Atlanta, and NYC being an individual record. If the person selects NYC, all of the records from NYC will appear even though Chicago and Atlanta are part of the string.
The following is the code for the current page:
[Code]....
On my website, registered users can make a profile about themselves suchas name, Favoirite color, hobbies, etcI have a DataTable called User which hold this information.also there are other datatables for Hobbies and Colors which list all possible options.To let the user update their choices I have a FormView in Edit mode on the aspx page whichis binded to the UserTable with a GetProfileByUserId Method and objectdatasource.
Within the formview, i have added drop down lists that are binded to the hobbies and Colors tables so they can edit their previous selection.On clicking Uodate update formview calls an Update Method that adds new selections to the User databaseNow I have two questionsIs it possible to show in the dropdown list the selected value that the User has already made?If the user only changes hobbies and not colors when they click update will a null value be passed into the data table for colors that replaces their previous selection?
i am making use of two listboxes. the data from one listbox is transfered to other listbox on button click, bt teh the data which is selected must be added to the table in the sql server. but it is not storing values it is throwing execption...
private void InsertRecords(StringCollection sc)
{
SqlConnection conn = new SqlConnection("Data Source=ABCD;Integrated Security=True");
StringBuilder sb = new StringBuilder(string.Empty);
[Code].....
I have a dropdown list inside gridview which has a object data source and I am adding the list items as true, false which stores in the database table as a bit value. Even if i am addin the values 1 and 0 to the drop down list, its throwing the below error'grdDebug' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value My code to add the dropdownlist with list items are as below
<asp:TemplateField HeaderText="Debug">
<ItemTemplate>
<asp:DropDownList ID="grdDebug" runat="server" AutoPostBack="false" SelectedValue='<%# Bind("Debug") %>'>
[code]...
I have used in line queries for inserting and retrieving data from database. How should i use stored proceduress
Insertion code
string strSQL1 = "select * from cust_details";
DataSet ds = new DataSet();
SqlConnection m_conn;
SqlDataAdapter m_dataAdapter;
m_conn = new SqlConnection(conn);
[Code] ....
Retrieval code
try {
SqlConnection conn3 = new SqlConnection(conn);
String q1;
//string ddl = DropDownList1.SelectedItem.ToString();
q1 = "select * from Product where ID ='" + DropDownList1.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(q1, conn3);
[Code] .....
I want delete, edit, select items is in grid view i have to do in c# code it will reflect to database also
View 3 RepliesI am using query string under gridview, when i click link on gridview "
Datas are in table,
add_cat_name(field)
Educational aides-Glass Decorators (Display the value in search related page)
Colleges-Arts & Science Colleges UG/PG (does not display the value because (&)
My coding
<asp:GridView ID="GridView2" GridLines="none" runat="server" AutoGenerateColumns="false" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<a href="search_related.aspx?id=<%# Eval("add_cat_name")%>">
[Code] .....
Using SQL and C#. I have a gridview with a template field. I need to modify the some items in the gridview when the user selects a given record and store the values back in the database. ProjectID is the unique key in the database.Gridview is done as a table. How can I do it? Here is my grid view implementation.
[Code]....
(The following is a complete re-edit of the original post which was rambling, confusing etc...)
I have a form with a dynamically generated checklist:
<asp:CheckBoxList ID="cblGames" runat="server" DataSourceID="sqlGames" DataTextField="Game" DataValueField="Id" </asp:CheckBoxList>
<asp:SqlDataSource ID="sqlGames" runat="server" ConnectionString="<%$ ConnectionStrings:Games %>"
SelectCommand="SELECT [Id], [Game], [ShowWaitingList] FROM [Aanbod] WHERE ([ShowWaitingList] = @ShowWaitingList)">
<SelectParameters><asp:Parameter DefaultValue="true" Name="ShowWaitingList" Type="Boolean" /></SelectParameters>
</asp:SqlDataSource>
The following code-behind is supposed to check those boxes that correspond to values stored in a database. It fails and I don't know why.
[Code]....
i've two tables trans-mstr having columns as acc_no_from,date,particular,wd_dt,amt,balance and third_party_transfer(table2) having columns as acc_no_frm,acc_no_to,date,amt.now i wnt to retreive date ,particular,wd_dt,acc_no_to,amt,balance where the acc_no_from in third_party_transfer is equal to the no.entered in the textbox of the webpage.i've used datagrid view to show all this.i'm using c# n sql server2005 in this i'm a beginer
View 1 RepliesI have two tables Users (Userid, Name, PhoneNumber) Applications (ApplicationsId,UserId, ApplicationName, ActiveDate)
Every user will have more than 1 application.
In Nhibernate using lazy loading I can get the users data along with all the applications for every user. So, I used to do something like user.applications[i].Applicationname to get all the applications.
But, Now how do i retrieve all the applications along with the users data using oracle commands. I know how to get one application using joins. But, how do i retrieve multiple applications and store it in a IList.
I'm using update panel in the master page. Half of my web page will retreive the data from the database in dynamic. As, my update panel is in master page(with ajax loader), it is taking much time for every event. Is there any other advanced method to get the data from the database instead of using update panel.
View 2 Repliesiam using asp.net with c#
iam saving two images in database but while retreving only one image is displaying
can you correct my code
[Code]....
I am trying to retrieve a Guid from the database but my application just isnt having it. I have a field in the database called "LoginUserId" and it is of type "uniqueidentifier".In my User Model I have:
[Code]....
I keep getting the error: Specified cast is not valid.
I have successfully used resources to translate my UI and I am now moving on to allowing the ability for the admin to translate database content.I'm looking for video tutorials / docs on database structure for localised info and how to retrieve localised data using stored procedures based on the selected culture.
View 3 Replies