Search DaniWeb - aspnet

Insert data to sql server using stored procedure and aspnet textboxes 13 Years Ago by Verygoodguy … my code bellow, supply me the corrections and the aspnet code that will display the identity in my label. …sql server express 2008. My goal is to insert aspnet text boxes data into the table using the stored procedure…have defined 5 textboxs, two labels and a button in aspnet webform as above: <asp:TextBox ID="lastNameTextBox&… Re: Insert data to sql server using stored procedure and aspnet textboxes 13 Years Ago by Verygoodguy Ya. I want the output parameter displayed in the following aspnet label control: "scopeIdentityReportLabel.Text". SpecialFolder.Desktop getting ASPNET profile not user profile 13 Years Ago by Pats2KDynasty … desktop path, but it is coming back with the AMachine\ASPNET desktop path instead of the profile path that I am… current logged in user but rather it is seeing AMachine\ASPNET as the current user or just taking the first profile… "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'." 17 Years Ago by spring_patel … "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'." my sql server uses windows authentication mode,and i… Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'." 17 Years Ago by majestic0110 Is your username VASANT\ASPNET ? if so, then is that the same username that was used to create the original database? Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'." 17 Years Ago by spring_patel … match my settings.... [QUOTE=majestic0110;573333]Is your username VASANT\ASPNET ? if so, then is that the same username that was… In reporting services got this error "The permissions granted to user sysname\ASPNET 14 Years Ago by vinayak.v … of reporting services.. "The permissions granted to user 'sysname\ASPNET' are insufficient for performing this operation. (rsAccessDenied)" when i… Deploying ASPNET website on heroku 3 Years Ago by nalb4242_ … -c Release -o out FROM mcr.microsoft.com/dotnet/core/aspnet:3.1 WORKDIR /app COPY --from=build-env /app/out… Re: Deploying ASPNET website on heroku 3 Years Ago by Dani This seems to be the same question as posted here: https://www.daniweb.com/programming/threads/535986/deploying-aspnet-website-on-heroku Aspnet flash in visual studio 2008 14 Years Ago by Enaks i tried installing aspnetflash from [url]www.aspnetflash.com[/url] in the process of installing, it always give me an error msg "CLOSE ALL.NET PROGS where as no program is open after installation i can't find the tool box on the Tool box menu am just confused. ASPNET DB hack 13 Years Ago by mshauny Hi I'm not an asp .net developer although I have done web development with php and mysql, I'm more of a software developer for desktop and mobile devices. So this is my first big project with ASP .NET. I have a question with the ASPNETDB database, understand that the database is either locked / read only . I need to use the same database to… Re: ASPNET DB hack 13 Years Ago by crishlay check ms-Sql connection string FIRST for login in Database... Data Source=(yourserver);Initial Catalog=databasename;Persist Security Info=True;User ID=sa;Password=password ASPNET Access Denied Save XML File 11 Years Ago by XEN0 windows 7 home premimum x64 access denied for saving files to app_data folder and any other folder in the projects root directory. Code below is what im using to save and getting... doc.Save(Server.MapPath("~/App_Data/Logs")) I get a couple access to path denied msgboxes. Set a few permissions and no go. Re: ASPNET Access Denied Save XML File 11 Years Ago by aarif.mansuri For which user you provided permisions ? Provide permisions for following user : IIS_IUSRS & EVERYONE Modify Read & Execute List Folder Contents Read Write Re: ASPNET Access Denied Save XML File 11 Years Ago by XEN0 Looks like i found the answer *chibi face here* ` Dim xmlName as String = TextBox1.Text` doc.Save(Server.MapPath("~/App_Data/Logs/ + xmlName + ".xml"")) Re: Insert data to sql server using stored procedure and aspnet textboxes 13 Years Ago by hericles You have the columns types specified as int in your command parameters but as varchar in your table definition. I think the SqlDbType should be varchar. You could always change your catch bracket to give you the real reason for the failure. [code] catch(Exception ex) { insertReportLabel.Text = ex.Message(); } [/code] Re: Insert data to sql server using stored procedure and aspnet textboxes 13 Years Ago by Verygoodguy The replay helped me a lot because I can now insert my students to a student table. But I can not see in my label the identity key returned buy scope identity from the stored procedure. Can anyone help? The overall code that is related to scope identity is 1. in stored procedure ... SELECT @Identity = SCOPE_IDENTITY(); 2. In … Re: Insert data to sql server using stored procedure and aspnet textboxes 13 Years Ago by hericles Is this the line where you expect the scope identity tone displayed? [code] cmd.Parameters["@Identity"].Value = scopeIdentityReportLabel.Text; [/code] Here you are setting a command parameter to be equal to that text box value. Seeing as you have already executed the cmd object I'm guessing this is in the wrong place. Re: Insert data to sql server using stored procedure and aspnet textboxes 13 Years Ago by hericles If your stored procedure returns a value then you will need to catch it in a variable. If it returns an int you will need: [code] int identity = int.Parse(cmd.ExecuteNonQuery()); scopeIdentityReportLabel.Text = identity.ToString(); [/code] Or something close to that anyway. At the moment you aren't using anything to hold the return value form the … Re: Insert data to sql server using stored procedure and aspnet textboxes 12 Years Ago by Hidayat62 con.Open(); cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "ClientInsert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int).Value = txtID.Text.Trim(); cmd.Parameters.Add… Re: Insert data to sql server using stored procedure and aspnet textboxes 11 Years Ago by nivabeath The given code samples is too long...please find the following link..shows how to use stored procedure asp.net with parameter values. [Stored Procedure with Parameter](http://asp.net-informations.com/dbpro/procedures-parameter.htm) Niva Re: Insert data to sql server using stored procedure and aspnet textboxes 10 Years Ago by sheejo.apsalone very nice post Re: SpecialFolder.Desktop getting ASPNET profile not user profile 13 Years Ago by thines01 If your code is running from ASP.NET, this is customary as you are not the local user. Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'." 17 Years Ago by majestic0110 I understand that VASANT is the server name what I am trying to get at is:is the username the same when the db was created as the username you are now using? (Ie. username = sa at both times) Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'." 17 Years Ago by majestic0110 just a thought, post your conn string: Does it include? [QUOTE]Integrated Security=SSPI;[/QUOTE] Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'." 17 Years Ago by spring_patel this is the connection string i'm using currently: [code]<add key="ConnectionString" value="Data Source=VASANT;Initial Catalog=MillTown;Integrated Security=True"/>[/code] Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'." 17 Years Ago by majestic0110 try changing "true" to "SSP1" let me know how it goes Re: Deploying ASPNET website on heroku 3 Years Ago by rproffitt I don't see why this should work at all given the error output. You need to resolve the errors given such as "CodeTaskFactory." YOU get to fix that and the other errors. Sometimes folk think this is a simple fix, sometimes it is but right there in the error is why. Let me ask why do this at all? If you want to run a website there… Menu control not working in IE6 15 Years Ago by apgriffiths …; height: 100%; display: inline; } .myMenuCSS ul.AspNet-Menu ul ul /*Tier 3*/ { top: 10em; left….myMenuCSS li:hover, /*list items hovered over*/ .myMenuCSS li.AspNet-Menu-Hover { width: 100px; background: #DC8700; display: … myMenuCSSIE6.css is as follows [code] .myMenuCSS ul.AspNet-Menu li /*Tier 1*/ { width: 1em; white… Mixing Forms and Windows Security in ASP.NET 12 Years Ago by ShaggyDogg …/08/mixing-forms-based-and-windows-authentication-in-aspnet/) [http://msdn.microsoft.com/en-us/library…com/csharp/.net/net_security/authentication/article.php/c19559/ASPNET-Mixed-Mode-Authentication.htm](http://www.codeguru.com…/csharp/.net/net_security/authentication/article.php/c19559/ASPNET-Mixed-Mode-Authentication.htm) Can anyone please …