C# - How To Hold A Table Of Data For User Edition (before Saving In The The Database) ?
Jan 18, 2011
I've been using this programming style, that I've seen in an example and just started using it, because it does the job... I would like to know other programmers' opinion about it...
So the situation is when you have a GridView, or a control based on it like the RadGrid, and you want to keep track of a data table while you are adding, editing, reordering and deleting rows.
Using the session to hold the data table (or list of data) may not be the best solution, because the user may open two identical web pages... Using the ViewState to hold the data may be and option... I have been using an approach like the following:
[code]....
So using a static List variable, of a custom object (class), declared in the code-behind of the Aspx page, and updating it whenever the data is edited.
I want to create a site where users can create a very basic profile, with fields like full name, City, Age and Gender, and I want the data for every new member that signs up to go into a simple Table in my sql data base. reason being I want members to be able to view other members info in a table. I am familiar with the "CreateUserWizard", but that only allows me to work with certain predefined info (email, user id, etc). If I just anually add new columns to the table in which user ID and such is saved to, and customize the CreateUserWizard controller to have text boxes for the additional data that I want (i.e. city), will the CreateUserWizard know to save that additional data in the table?
Also, I know I can add fields to the <profile> tag in the web.config files, but I dont know where that gets stored. I want all the info for the user to be stored in one table in a sql data base so that I can easily access it with a quary. I dont see where the profile properties get stored, and how it can be linked to a User ID. by the way I noticed in other posts, there was a mention of a membership provider. I noticed that although I've added some "Login" controlls (i.e. login and CreateUserWizard), no membership provider has been added to my web.config file. Do I need to do this manually? or is there a menu item that adds it for me?
I have a requirement to have a multiline textbox that accepts any text from any language and stores this into the database for later use. I am using Linq with ASP .NET 3.5 with a SQL Server 2005 database.
I'm New In Asp.net , And I Wanna to know how can i display an alert to the user that inform the saving operation was done successfully and refresh the page to clear all the textboxs in the form to insert a new record in database ??
I have a table for labels in SQL server, in this table i hold all the text for all the labels i use in my website. The reason i am doing this is because i creating a bilingual site, which will display two languages on one page at the same time. The other language being arabic.
So what this means is that whenever a page loads, it needs to go and fetch the text of the labels from the database to display them on the page.
the way i have done this is that i have created a class called labels, and in this class i have created two methods, one called GetEnglishLabel(ID) and the Other Called GetArabicLabel(ID). Both methods take an ID, which corresponds to the id in the sql server database. Each of these functions is using LinqToSql to get the text for the label for the given ID.
My problem is that for every label i need to call this function, so as you might imagine on one page i might have over a hundred calls to these functions on page_load.
I have a app that records some jobs and those jobs can have notes attached therefore i connected the table with a foreign key, my notes to a Job.
in the details view of the job i allow the user to view the jobs by sending the id and fulling all the notes that match the id in the index view for the notes table. in the list of notes i have a action link to create a new note, here i sent also the id of the job to the create action of the control and try to insert that intot he note JobId to make the reference. I get this error and the note is not created. the note creats from code but not via the note controller creat action.
i get this - An error occurred while updating the entries. See the inner exception for details. below is the create action in the note controller
public ActionResult Create(int id)
{ // var newnote = db.Jobs.Include("StatusNotes").Single(j => j.JobId == id);[code]...
i want to save data from three textboxes into one cloumn of database. i have there text boxes for phone no field..one for country code, 2nd for area code and third for number..
I first create a Dynamic table with textboxes and other controls in the cells. A user then enter data into the controls and I try to save the entered data to an access database. but when A save button is pushed the controls are not found.
I have a basic one cell asp:table on the page called "Table1" and then I append this table by using the Controls.Add(TableBuilder()) function in the Page_Init().
How the code basically works:
Public Function TableBuilder() As Table dim r = New System.Web.UI.WebControls.TableRow() Dim c = New System.Web.UI.WebControls.TableCell() a = New TextBox a.ID = "Sunday" c.Controls.Add(a) r.Cells.Add(c) Table1.Rows.Add(r) TableBuilder = Table1
The table shows up fine but after I press the save button I look for the created control to get the value the user entered it says the control is not there.
SaveButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim txtSunday As TextBox = Master.FindControl("MainContent").FindControl(("Sunday")) UserEnteredData = txtSunday.text
But if I call TableBuilder() at the start of the function the control is found but the value the user entered is gone.
SaveButton_Click() TableBuilder() Dim txtSunday As TextBox = Master.FindControl("MainContent").FindControl(("Sunday")) UserEnteredData = txtSunday.text
Our application lets the administrator create new users. Since the administrator is logged in, I have set Logincreateduser = false so that the administrator is not logged out even after creating the new user.
The problem is :I need the userid of the newly created user to store additional details of the user in another database table. I see that i can get the username using Createuserwizard1.username; but how do I get the userID?
then the database table is created in database(that is SQL express),how can do that.Please sir help me in that problem.I try that thing and debug the code and there is no error in the code but when I click the button in run time ,no table is created in the database(which is placed in sql express 2005).So my problem is that why the table is not created in the database. [code]...
My question is that if the user click on button (which is place in default.aspx, for example) then the database table is created in database (SQL express), how can do that? I have tried but errors are occuring during debugging, errors are:the best overloaded method match for 'system.data.odbc.odbc command.odbc command(string,system.data.odbc.odbc connection)'has some invalid arguments. Argument'2':cannot convert from 'system.data.sqlclient.sqlconnection' to 'system.data.odbc.odbc connection'. The code written in c# behind the button (button is placed in default.aspx, for example) is:
using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; [code]...
Both visual studio 2008 express edition and visual studio professional setup's are install in my system, i like to uninstall visual studio 2008 express edition, and use professional edition. is there any problem arises in visual studio professional edition, if i uninstall visual studio 2008 exp edition
Im passing sensitive details from my asp.net web app to a database on a different server. I've set up encryption on my database. Should I encrypt the data in the code behind file of the web app and then pass it to my database stored procedure or pass it to the stored procedure as it is and encrypt it there?
I created a column named InputUserId for the purpose of saving the user's id upon inputing data using formview(so I know who inputed). I would like the user's id to be saved in the table (column InputUserId) and the table's Id (RId) to be saved in the user's profile.
I'm getting an error message: Object reference not set to an instance of an object.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error: [Code]....
I am trying to bind my dataset to a datalist. I know I can use a databind methed but Im also trying to do something else like modifying the dataset. What I want basically done is, if the user is not signed in, it will populate my datalist which is mostly checkboxes with texts. But when the user is signed in, i want his history of his checkboxes that was save onto the database.
Company array is a string array where i have stored the company ids
the problem is company_array[0] has the initial value of the dropdownlist(company) --select company which is why m getting the error(cannot convert data type nvarchar to int) . I have used the same logic in many places in my project it did not give any error.
int count = 0; company_length = company_length - 1; while (count < GridView3.Rows.Count && compid_counter < company_length ) { cmd = new SqlCommand("insertWorkDetais", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@trainerId",trainerID);
I am facing one problem with data connection in my MVC2 project. I couldn't able to connect to SQL SERVER Database, the error says "Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the [URL]
1. Just create a new MVC project 2. I did right click on App_Data and choose Add new item 3. Selected the "Data" option at left hand side and gave a name for the mdf file which is same as my current database mdf file name. 4. After that, clicked on Add button. 5. Then i got above error messages. 6. So do i need to install SQL Server Express 2005?
I tried in VS2008... Tools -> /Options -> Database Tools -> Data Connections, and changing "SQL Server Instance Name (blank for default)" to connect to my instance name but still it didn't work. I couldn't connect to the database from visual C#. I have read several threads about it but I couldn't get any good solution that can solve my issue.
I used the following link to add textboxes inside Gridview and saving data to Database.URL...The above article is very useful, but my problem is I want the Textboxes to be display in Rowwise instead of Columnwise. Means like I need to display is
Name texbox1 Age texbox2 Salary texbox3
SAVE ButtonThen SAVE button to save data entered in the textboxes to the database. Gridview design to achieve like this.
