I have two formviews and two datasources on a page.
The first shows data from datasource 1 in various labels.
The second shows only a 'new' button to switch to insert mode.
On the seconds insertmode, id like the data in textbox1 to be already filled with data shown in the first formviews label1 (or [id] from sqldatasource1 if thats better?)
Scenerio:
I have 20 records retrieved from DB.
Each record is being displayed in a formview. I want to export all '20' records/formviews to a PDF file.
How can accomplish this?
1. Can I have two different controls with the same name in two different formviews on the same page?
I have text boxes named the same in a few different formviews on one web page.
2. How do I autopopulate the rest of these text boxes once a value is entered in the first text box. I want the same value that was entered in the first to be automatically entered into other fields in different formviews..(same page)
I have a nested FormView and I need to get the values from some of its controls (TextBox) in code behind.
I can easily pull the values from the "parent" FormView using:
TextBox txtBox = (TextBox)fvParent.FindControl("txtField");
String myStr= txtBox.Text;
Although, when I try to get a refence to one of the controls in the "child" FormView I get a null. I am trying to do this:
FormView formView = (FormView)fvParent.FindControl("fvChild");
TextBox txtBox = (TextBox)fvChild.FindControl("txtChildField");
String myStr= txtBox.Text;
The variable "formView" is set to null. Can the FindControl method not find nested items? If not, what is the proper way of getting the values from these fields (in the Child/Nested FormView)?
I have tried several ways but just cannot figure our how to populate some formviews with the data I have brought up in a gridview.
Here is my code so far. I just showing the code behind because my gridview and forms are not a problem. Where I am stuck is at the GridView1_SelectedIndexChanged at the bottom of the code.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.UI;
[Code]....
I have a very complex page with 11 formviews, 1 dropdownlist, and 11 sqlDataSources.I have several issues
Page: This page controls my website users and their info. There are 2 different users with 3 different permissions; users - 1 Primary(account Creator), and the rest; Permissions - View, Edit(Manage), Create/Delete(Author)
Each Formview controls one column in the table.
1st. After Permissions are read, the add, delete buttons are to be disabled if no permission. If the User selected is the PrimaryUser the delete button is disabled. On Page load, the delete button is enabled even though the displayed user is the Primary, when you select another user, then select the primary again, the delete button is disabled, but when you select another user the delete button is still disabled. This should not be!
2nd. I then added a check to see if there was one or more locations, and if there is only one, then disable the edit button that allows a user to assign a user to a specific location. example: if there are 3 locations, you may assign a user to that office location, but if there is only one location, there is no need. I try to disable the edit button in formview, but I get "object reference not set to instance" which is total cr#$ because the button is there in the form.
3rd. When a page loads and all of your sqlDataSources have a Select controlParameter that is determined by a DropDownList, how is the initial record determined other than it is the first record?No matter how I work my code, these issues do not work, and it is very frustrating and holding my project back. I have been working on thes for a week.
[Code]....
This is the first time I have been working on databases and I am trying to insert data using an object datasource but no data is being inserted and no exception is thrown. I'm not sure where I am going to wrong. I am putting user data into session variables and inserting the session variables into the dataacess class layer and have a try and exception but nothing being thrown. Any help would be really appreciated because I don't know even where to start looking with this or how I can get the error to be thrown. Please see some of my code below to give an idea of what I am doing
Object Access Class
public void InsertCarPolicyHolder(PolicyHolderClass ph, CarInsuranceOptions options)
{
[code]...
I am building an app (ASP.NET 3.5 + SQL 2005) that allow users to schedule meetings and these meeting will show in the users to-do list.
One kind of meeting, when scheduled, should show into ALL users to-do list.
I have 3 tables:
#1 - Users -> UserID
#2 - Meetings -> MeetingID
#3 - Member_Meeting -> UserID+MeetingID
What I need is:
Based on the scheduled meeting, read all users from table #1 and add their info in the table # 3 with the MeetingID (which I can get from the UI, because it will happen when they create the meeting).
I have been browsing about it, but so far, I couldn't find a good source of info to start with.
I have two tables cust and order_cust cust table have cust_id, name, addr, zip columns and order_cust have order_id and cust_id columns I take input from user for cust table i.e. name, addr, zip... the cust_id is an IDENTITY column so generates the value automatically Now I want to insert the last generated cust_id into order_cust (order_id is also an IDENTITY column)
How can I achieve that using stored procedure?
I want to insert data in my tblOrder with surent paramater
I get the controls out of al my paramaters.
But ons of my controls contains the text of a Title of a book.
In my table i want to to insert this book_id. The title of this book is in an other table tblBoek. But i want to enter al my data in tblOrders.
TblOrders Tbloek
ID ID
Naam Titel
Boek_ID Auteur
the Boek_ID is i an relationship with the ID form tblBoek
SQL:"INSERT INTO tblOrders (ID, NAME, ADDRESS, DATE, BOOK_ID,) " +
"WHERE
"VALUES (@Id, @Name, @Address, @Date, )"; //for my parameters these values are in controls
"FROM tblOrders INNER JOIN tblBooks ON tblOrders.BOOK_ID = tblBooks.BOOK_ID";
SOMETHING WITH WHERE
but the books ID doesnt work without it it will
Whenever I run the following code to insert a record into database:
protected void Button1_Click(object sender, EventArgs e)
I have this code and not sure what is wrong.
csconnection = New OleDbConnection (Stringconnection)
cscommand = new OleDbCommand("INSERT INTO Login ([Username], [Password], [Name], [DOB], [Gender], [Nationality]) VALUES (@Username, @Password, @Name, @Dob, @Gender, @Nationality);") [code]...
it just says errorat bottom of page and is there a way to tell the webpage to show me the error.
i want to insert the value in sql data base.in table id coloum is unique.because of this i cant able to select not null type....so i cant able to insert the value in data base.
View 3 RepliesI am trying to get some guidance with this issue:
I have a Customer object that has two address ID fields (one for HomeAddress and one for WorkAddress)
I am loading the Address Objects by using Include="HomeAddress, WorkAddress" and then binding to the properties using the Navigation Property on the Customer Entity
Can I use just one FormView for doing the Insert/Updates and binding it to an EntityDataSource or would I have to do all the Inserting/Updating manually?
I am having trouble inserting data into the table using dataset..following is my code:
[Code]....
The m_id is a primary key..I want to auto-increament it everytime a data is inserted into the table so I have configured (isIdentity) to Yes and Identity increament to "YES"..I don't know if its right or not..I already added some data manually into the table but now I want to add more data using the above code..but its not working..
[code]....
I have created database in sql server 2005 using Snowflake model.
Problem :
There is 1 fact table and 3 dimension tables.
Suppose Fact Table has cols : sales_person_id, cust_id, product_id and dimension tables as per id s defined in fact table.
Suppose i want to update products in product table, i am able to do so.
but i can not update product_id in Fact Table because remaining two field will be NULL.
i have built an inserting interface in a GridView's Footer Template. Added Button for insert , auto generated the insertCommand in SqlDataSource. But then how to Bind the data of inserting interface to insert command of SqlDataSource ?In FooterTemplate. i have taken TextBox.GridView's RowCommand Event is handled in this way.
[Code]....
(all that i did , i took help from this web site's tutorial)
So,How to insert data?
I have a textbox which the user writes a word into. They then press a button to add that word to a list which is stored in the database.
What is the code to do add their word to the database? Do I need code on the main aspx file or only on the code behind?
What I tried doing up until this point is that once the button is pressed, in the codebehind the following happens:
[Code]....
I get errors telling me that the column name Program is invalid (I have a table named Program with one column named ProgramName)
I looked at a bunch of tutorials but nothing is straight forward and simple, it keeps confusing me. I need the simple step by step instruction to do this. I'm using a SQL database and coding in VB
Im Inserting data into database table with the help of datasets but its not inserting to table and even its not showing errors.
this is my code....
[code]....
i am trying to display a pop up message box on inserting the data into the database. The code i am using is as follows..
[Code]....
The problem is even on inserting the data and the data getting inserted into the database, the pop up mwindow does not get displayed. On debugging, it shows the value of i as 0.
I am doing a management system . What i am trying to accomplish is that when a user fill form relevant to management system the data should go into respective tables.How to accomplish this.I am using primary keys and foreign keys
View 3 RepliesAfter creating a dataset, which has CRUD statements generated two or more tables, which Data Control should I use that will allow me to insert data into fields into 2 or more tables from a single web form. I'm trying to create a web form that will allow the user to input student information, such as general information, medical information, etc.
View 3 RepliesI m getting following error in my eventvwr . I couldnt find reasons of the following error.
"Transaction (Process ID 110) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. "
The only thing my page is doing is inserting/updating data into a table in sql and the thing I can think of is because multiple users are using the same page to insert/update data? Will that cause deadlock?
I have requirement that User can Upload the Excel Sheet Data to sql server Database at once.
View 16 RepliesI have created a simple dataset with my ObjcetDataSource to my SQL table named Invoices and a new FormView. My form inserts are working 100% correctly, however after some testing i noticed the insert happens again if i hit the refresh button on my browser after an initial insert. I am currently submitting the form back to itself with a success/fail message returned on the page so that the user can keep inserting more records if they choose. This is done in my Inserted behaviour.
In my ObjectDataSource_Inserting code i am setting the values of a date prior to my insert. How do i stop a second INSERT from happening when the user refreshes the browser? I thought it was what IsPostBack was used for? Here is my code:
[Code]....