I have 3 tables and I need to display ListBox and need to have facility for add/update facility. Here are the tables
Table 1 - PROJECT
Table 2- PROJECT_PRODUCTS
Table 3 - PRODUCTS
Now I have to Display PROJECT table for creating/editing and while doing it I would like to display ListBox(MultiSelect) for Products and I would like to know how can I implement this for editing?
I have a gridview with a select command.. When user selects a row.. I need to populate 4 dropdownlists with the values in gridview, dropdownlist which are also populated at page load event...
Though there is value in the dropdownlist when i try to update it selects 0th value.. Since while updating i use drptask.selectedvalue.tostring() since i am saving int values in database
It stores value as 0 in database..
i have popup on my webform with name and email id submit button,So when u click on submit button the name n email is entered into SQLSERVER database.As user click on submit a verification link should be sent to him table named "SUBSCRIBE" in database having columns :Name, Email, Date Time,Validated,ValidationEmailSent,Validation code.where name n email will come from as user entered....but others has to b generated. where
validation=if clicked on link den 1 otherwise 0;
validation Email = if email id is proper value is 1 not proper value should be 0;
validation code is ramdom no;
values of this 3 columns will b updated in database as per user response. How to write code for this problem as i have never used database sql server???
Lets take an example of online ticket booking system. Many users could be booking the tickets at any point of time. a GridView displays the list of Allotted and Free seats If a seat gets booked, this information must get updated in all the opened pages in user's browser. User need not require to refresh the page to see if a seat is booked or not Should i put GridView in update panel and keep looking into the databse constantly ??? This could turn out to be a heavy work if databse is too large any other alternative?? or should i stick with the above approach....?
View 10 Repliesi am trying to update table but geeting error
"System.Data.OleDb.OleDbException: Syntax error in UPDATE statement."
here is my code :
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string Id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
TextBox txtDate = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtDate"));
TextBox txtAction = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtAction"));
TextBox txtScrip = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtScrip"));
TextBox txtnBuy = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtnBuy"));
TextBox txtSell = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtSell"));
TextBox txtremarks = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtremarks"));
TextBox txtTarget = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtTarget"));
TextBox txtDifference = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtDifference"));
TextBox txtProfit = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtProfit"));
con.Open();
OleDbCommand cmd = new OleDbCommand("UPDATE performance set ndate='" + txtDate.Text + "',Action='" + txtAction.Text
+ "',Scrip='" + txtScrip.Text
+ "',nbuy='" + txtnBuy.Text
+ "',nsell='" + txtSell.Text
+ "',remarks='" + txtremarks.Text
+ "',Target='" + txtTarget.Text
+ "',Difference='" + txtDifference.Text
+ "',nprofit='" + txtProfit.Text
+ "' WHERE nid=" + Id, con);
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
bind();
}
<asp:TemplateField HeaderText="Date">
<ItemStyle Width="100px" />
<EditItemTemplate>
<asp:TextBox ID="txtDate" runat="server" Text='<%#Bind("ndate")%>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("ndate") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Action">
<ItemStyle Width="100px" />
<EditItemTemplate>
<asp:TextBox ID="txtAction" runat="server" Text='<%#Bind("Action")%>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%#Eval("Action") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Scrip">
<ItemStyle Width="100px" />
<EditItemTemplate>
<asp:TextBox ID="txtScrip" runat="server" Text='<%#Bind("Scrip")%>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%#Eval("Scrip") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Buy Level">
<ItemStyle Width="100px" />
<EditItemTemplate>
<asp:TextBox ID="txtnBuy" runat="server" Text='<%#Bind("nbuy")%>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%#Eval("nbuy") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sell Level">
<ItemStyle Width="100px" />
<EditItemTemplate>
<asp:TextBox ID="txtSell" runat="server" Text='<%#Bind("nsell") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%#Eval("nsell") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Remarks">
<ItemStyle Width="100px" />
<EditItemTemplate>
<asp:TextBox ID="txtremarks" runat="server" Text='<%#Bind("remarks") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label6" runat="server" Text='<%#Eval("remarks") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Target">
<ItemStyle Width="100px" />
<EditItemTemplate>
<asp:TextBox ID="txtTarget" runat="server" Text='<%#Bind("Target") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label7" runat="server" Text='<%#Eval("Target") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Difference">
<ItemStyle Width="100px" />
<EditItemTemplate>
<asp:TextBox ID="txtDifference" runat="server" Text='<%#Bind("Difference") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label10" runat="server" Text='<%#Eval("Difference") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Profit">
<ItemStyle Width="100px" />
<EditItemTemplate>
<asp:TextBox ID="txtProfit" runat="server" Text='<%#Bind("nprofit") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label8" runat="server" Text='<%#Eval("nprofit") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<EditItemTemplate>
<asp:LinkButton ID="link1" runat="server" Text="Update" CommandName="update"></asp:LinkButton>
<asp:LinkButton ID="LinkButton3" runat="server" Text="Cancel" CommandName="cancel"></asp:LinkButton>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="LinkButton4" runat="server" Text="Edit" CommandName="edit"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete"
Text="Delete"></asp:LinkButton>
<ajaxToolkit:ConfirmButtonExtender ID="ConfirmButtonExtender1" runat="server" ConfirmText="Are You Sure Want to Delete" TargetControlID="LinkButton1">
</ajaxToolkit:ConfirmButtonExtender>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle BackColor="#9cd3fa" />
<FooterStyle BackColor="#CCCC99" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
I have a C# DotNet application and an SP of SQL Server 2005. I had made changes to the SP. I found that the connection string of database in the web.config also is correct and it is pointing to the same database in the same server but after changing the SP and checking form front end I am not able to get the updated SP results. After changing the SP do we need to build dll of middle tier again? What all changes I need to make. When I run the SP individually it is giving correct updated results. i had done IISRESET also after chnaging the SP.
View 1 RepliesI have got an issue after updation in UpdatePanel. The issue is the jquery events are not working/firing after the updation in UpdatePanel. At first time, the jquery events work, but not after the updation in UpdatePanel. If I remove the UpdatePanel, the problem is solved. But I have to use the UpdatePanel.
View 1 Repliesi have bind griview dataSource with Store procedure having join of 3 table how can i update this gridview data using stored procedure?
View 5 RepliesHow to do CRUD in LINQ?
how to perform updation using linq where i have multiple conditions for for single row and updating multiple fields to that row?
I have many divs in 1 page and each div consists of a gridview, the gridview is loaded by making AJax calls. On load of the page, all the grid load data properly. But now when i update any row in either of the grids, and make a call to the javascript that loads the grid in the page, it doesn't work rightly. Wat are the options to update/refresh the grid.
View 1 RepliesI have GridView with no data source. That I have persisted in memory.When editing row, I have fetch data to ModalPopup. When I edit data on ModalPopup using button click, how to find row index?I mean, how to find which row has been updated?
View 15 RepliesI was reading through this post here http://www.misfitgeek.com/op-ed/adding-asp-net-membership-to-your-own-database and thought to my self what the common practice is. What do developers using ASP.NET membership and authorization in their applications recommend as a best practice? creating the membership tables in the same database that stores their applications data or configuring a second database to store ONLY the membership information?.
My current setup is a different database for membership information ONLY but am thinking that increases the number of databases i have to maintain. If I have 5 applications using asp.net membership, then that means 5 more asp.net membership databases. So do you normally create the asp.net membership tables in your main database or you configure a separate membership table? what do you recommend.
I'm really not a database person, so forgive me if this question. I'm using visual studio 2008 and i am trying to view tables on another server database. Example
I have my aspnetdb.mdf database, and my anaylsis.mdf database. What i am trying to do within visual studio is read table colunms that are inside aspnetdb.mdf from anaylsis.mdf.
I'm developing Web Desktop like Glide or Icloud. It's gonna be a web application that gives the real world desktop application functions.
The DBMS I'm goin' to use is SQL Server. Now, I'm designing the database schema, but having some problems with it. I've no idea what tables I've to include.
So far I've only Users, Folders, Files, RecycleBin, Contacts, ContactGroups tables, but it seems very few. May be I've missed something.
IDE: MS Visual Studio 2008 / SQL Server 2005 Express / SQL Server Management Studio Express 2005
Skills: BeginnerI was trying to delete a table from my database ASPNETDB.MDF ,that DB was previously used for User login information i made it by using asp.net built in login support by opening ASP.NET configuration ,but now i want to built my own simple login control...so i want to remove all the tables made by ASP.NET configuration.I got this error when deleting one of the table"Could not drop object 'dbo.aspnet_Applications' because it is referenced by a FORIEGN KEY constraint"
I'm trying to use a DataSet to maintain some rows for a table, and when I've finished my changes, send all changes to the database using a SqlDataAdapter.
I find if there are no rows in the table in the database then I am getting a 'Object reference not set to an instance of an object' when I try to access the table in the Dataset.
Is there a way to work with a Dataset like this ie. I start off with an empty table and I wish to add rows, to access the structure of the table rows, build rows, then add them and do the update on the SQLDataAdapter.
Here is my code:
[Code]....
How do database and tables get created when I am pressing create user wizard in asp.net?
View 1 RepliesI want to retrieve the name and phone columns from all the tables in my database not in systables.
Ok this works but i dont want to get it from just the test table I want to get it from all the tables that I create
"USE mrpoteat SELECT name, phone FROM mrpoteat.dbo.test where name = name and phone = phone"
What would you all suggest a database with less number of tables and more number of columns or more number of tables with less number of columns. I am developing a web application using Visual stuio 2005 and Sql Server 2005
View 2 RepliesI want to know that how many tables we can have in database and what is the maximum no. of columns.I also want to know the maximum size for each datatype.
View 3 RepliesI am using aspnet_regsql.exe to add membership tables to my database.
when I click the exe file it just opens up an XML file in visual web developer and does not start the wizard to merge the databases.
the run command where file is located is below
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727
I just get the file below opening instead
[Code]...
I want to add custom columns to some tables created by ASP.NET. For example; I need to add two fields such as FirstName and LastName to the aspnet_Membership table.
I can add this directly by editing the table but;
Is this the right thing to do (I mean; extending the table directly) OR should I create a separate table and hold the extra user data, there?How can I see these custom database fields as properties in code completion? example: membershipuser.FirstName;
I have created a search page which outputs results in a repeater. It uses a stored procedure to search a table %like a textbox value, what's the best way to make it search multiple tables and output the results on one button click?
As i could just use seperate stored procedures and repeaters for each table i want to search, which is only 2, but this seems inefficient.
I have 2 tables in SqlServer 2008.
Table1: T1id, SomeData
Table2: T2id, T1id, SomeData
I am using DataAdapter.FillSchema to create shema of tables in DataSet. I created DataRelation on columns
T1id in both tables.
Now when i try to Update Sql Database T1id in Table2 remains 0 and not the value of T1id in Table1.
I can successfully update Sql Database if i fill DataSet with records first (Using DataAdapter.Fill), but that's not what i want to do. I don't need "old" records in my dataset. I want to use dataset just to store all imputs from user until the proccess is done and then insert all those records "at the same time".
Is there any framework or tool to generate web services (WCF) access to all the non transactional tables in my database? something like asp.net dynamic data but with web services, I need to do this for homologation with other systems.
View 3 Replies
