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 Replies
I 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 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]....
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 RepliesI 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 Repliesi am doing a web page in asp.net which holds logos of members in the page in a grid view.each cell is a link to the relevant member's website.
i want to popup an image of the member's website when the mouse is hovered over a certain cell. for this a snapshot of the website is stored in a database an for the onmouse over event i want to make it pop up.
i want to know whether using ajax or JavaScript is more appropriate for this problem.
i want to know how this can be done.
I have been able to save an image in the database but i can not preview it
View 4 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.
Is linq just for retrieving data or can you send data to the database using it?
View 3 RepliesI 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 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'm having a question about retrieving data. I'm using VS 2008 and I have to create a new consultation record for a patient and I've already created a database with 3 tables, which are doctor, patient and consultation.
I have 10 records saved in consultation table, and I've made a aspx form which contains a DetailsView that ask for new consultation details to be added. But I have to be able to get the doctor and patient information from the database and put in the DetailsView, then fill in the rest of the consultation details. The information entered have to be written to the database in the consultation table. But I don't know how to get doctor and patient information from database and apply them into the DetailsView so that doctor who wants to add new consultation details can select patient and doctor information from the database.
I was thinking maybe I need to do a query with insert statement and apply into the DetailView,this is the query i have:
INSERT INTO [Consultation] ([ConsultationID], [GPname], [PatientFirstName], [PatientLastName], [Height], [Weight], [IllnessDescription], [Diagnosis], [Date]) VALUES (@ConsultationID, @GPname, @PatientFirstName, @PatientLastName, @Height, @Weight, @IllnessDescription,
@Diagnosis, @Date)
as you can see, I need to get the GPname, PatientFirstName and PatientLastName from the database tables and the rest will be filled in by the doctor.
i 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 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] .....
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 want to be able to take a select statement like: SELECT password FROM table WHERE user_name = @user_name and compare it with what was entered in a form text box. I have tried:
AccessDataSource1.SelectParameters("password").DefaultValue
= TextBox1.Text
AccessDataSource1.Select() (not sure how this works or what to set it equal to)
I also tried to connect to the database with a basic ADO connection that I got off another forum, with no luck
I want to retrieve the values from two columns in a database, but I get an error. Here is my code:
[code]....
i am a beginer and i want to know how to store images in the database tables like pictures of the pizzas and when the user selects one of the pizza from the dropdownlist he sees the image of the selected pizza.
View 2 Repliesi saved files into database. when i'm displaying i wrote code like this
Dim mySqlDataReader As System.Data.SqlClient.SqlDataReader
Dim mySqlCommand As New System.Data.SqlClient.SqlCommand("pl_Resumes", mySqlConnection)
mySqlCommand.CommandType = CommandType.StoredProcedure
[code]...
I have a database where i have the physical path where image of a person is stored . now i want a code by which i can display the image of that person in a aspx window.
as i am new to asp.net & C# can somebody provide me the full code of aspx page and the C# code behind it?
I have an aspx form that is meant to add a new prescription for a doctor system. I've created the database and dataset needed, but the problem is that the doctorID and patientID has to be able to select from the database, not entered in as a plain text. The form look something like this (I did this in DetailsView in MS Visual Studio 2010):
DoctorID: [textbox]
PatientID: [textbox]
prescription details: [textbox]
Insert Cancel
as you can see, only the prescription details needed to be entered in and the doctorID and patientID needed to be selected from the database (in a dropdown list maybe) and it shouldnt allow any text to be entered in. I did the above tables using a DetailsView in Microsoft Visual Studio 2010. However I can't seem to make the doctor and patient ID field be dropdown box which allow me to choose the current doctor and patient in the Doctor and Patient table in the databse. Can anyone tell me how to do it with Design View in Visual Studio?
I am wanting to insert a record into a table in SQL then retrieve its key at the same time, the key is a int that is automatically generated, I read something about the '@@Identity' function, is this what I need? How could I then bind this to a label in the ASP.net page?
View 12 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]....
