Web Forms :: Implement Database Transactions In Code In C# Application
Dec 28, 2012
I want to insert in two table at the same time.I write this:
DALBase MyDALBase = new DALBase();
int categoryId=Convert.ToInt32(MyDALBase.ExecuteScaler(System.Data.CommandType.StoredProcedure, "insertmainmenu", new SqlParameter[]{
new SqlParameter("@NodeName",txt_mainmenuname.Text),
[Code]....
but the problem is I havent access to categoryId before InsertI need categoryId to make a Urlstring url = txt_ MainEnName.Text + ".aspx" + "&CategoryId=" + categoryId;@Url =urlHow can i do it?
I just want to know the concept of commit Transaction and Begin Transaction in Asp.net with c# language, I have a certain code in c# given below... where I declare commit transaction and begin transaction. my code is:
public void dial(string traid, string trakey, string account, string ttref) { try { string[] result = new string[4]; SqlConnection sqlconn_cms = new SqlConnection(sqlconn_cmsstr);
i got an requirement where in the user submits the database scripts,stored procedures ,triggers ,functions or packages.i have create those in the database .if it throws an error it must be roll backed.how can i achieve this.
there are some way of generating the application form source code for an database tables in c#, but i not need a dynamic application form like Scaffolding i need the source code of application form
I need to implement a chat application in my asp.net C# used Web Application. I am looking a 1 to 1 chat . Here i am users and i need to chat those users with other ones.
i want to impliment multithreading into my web application how to do that..
i have already knew the concept of multithreading but want to impliment into application..
i have developped an application this application runs correctly for 400 users but when more user hits the server than the application fails to respond...
how improve the performance of the application..is this problem is related to the database server of the application server.
"We should also have an option under the contacts tab, for a chat option .The idea behind it is that if a user is looking to communicate with a staff person they should be able to open a chat session and start a typing their questions and/or concerns. While building the chat option, the chats should be logged for certain period of time and there should be an option of retrieving particular chat sessions as needed."
What is the best way to implement this ? I prefer jquery plugin for implementing the above task () ? I am using asp.net 2.0.Is there any need to update to 3.5 to achieve the above task ?
I am going to create application, in that application, i need feature of single sign on application.if i am login with 1 application, i suppose to login with others application.ex. if i login in gmail, then i automatically login with You Tube...
I was used Repeater and DataList for this, but they don't show like that.When using DataList :
My code :
<asp:DataList ID="dtltag" runat="server" EnableViewState="False" RepeatDirection="Horizontal"> <ItemTemplate> <div class="tag"><a href='<%#Eval("tag","Paper.aspx?tag={0}")%>' ><%#Eval("tag")%></a></div> </ItemTemplate> </asp:DataList>I don't want limit my DataList with RepeatColumn , i want wrap tags when it necessary.Which control should I use?
I have a requirement to log all/most forms authentication transactions that take place within my page. For example, if someone is kicked out because of forms authentication, I'd like to get their username, time when kicked off, and where this happened. Is there a good way to do this. Better yet, has anyone done this already and is willing to share some code or post a link?
The database has been designed for a tradesman web site, i.e. Plumbers, Builders etc. The two main tables are tblCustomer and tblTrader which will stored data from two frontend web pages where the customer and trader can enter their personal details. After a customer enters their personal details (i.e. registers through the site) they will then be directed to a child page where they can progress to entering a specific job attached to a specific trade (i.e. Plumber) and trade type (i.e. Bathroom Installation), once a customer job has been entered I want these details to be emailed to all the trader_email addresses from tblTrader, from this email alert the traders will then enter the system and offer quotes to the customer through tblTraderQuote where the customer will then accept the best quote for them.
What I also want to implement is some sort of rating option that will allow the customer to rate their trader, either something like ebay's feedback or just a simple 1-5 rating option? How can I implement this into my database design or is this something that should be performed within the programming layer?
In a Web server is running. NET Framework 4.0. Whatever the methods and technologies you would advise me. applications built on the basis Asp.NET MVC 2.
I have a database table in MS SQL Server. For each table in database, I must implement the interface for viewing, editing, and deleting. So code generator must generate model, controller and views.. Generation should happen after clicking on the button in WEB UI.as Model I use .NET Entity Framework.
Now, I need to generate controllers and views.
So if i have a table with name tableN1. and below its colums:
[ID] [bigint] IDENTITY(1,1) NOT NULL, [name] [nvarchar 20] NOT NULL, [fullName] [nvarchar 50] NOT NULL, [age] [int] NOT NULL [active] [bit] NULL
agree: if the type bit, then generate a checkbox. nvarchar (20) - textbox nvarchar (max)-textarea and so on.
for this table, i want to generate views and controller.
I have implemented master pages using this example How to implement a status bar in an ASP.NET application?. I have a property on my SiteMaster.cs inherited MasterPage called Environment. On my MasterPage.master I have this code:
<body> <form id="frmMaster" runat="server"> <.. some content removed for brevity ...> Environment: <%= this.Environment %> </form> </body>
What I would like to do is evaluate this.Environment and if it is "LIVE" then colour the background of this.Environment text red, and if it's "TEST" colour it yellow. How would I do this?
UPDATE I've just added this code to MasterPage.master
