[stored] Forum Topics

Hi, Does anyone know on how to convert vb.net to excel. I am new in this company and they are using Microsoft SQL Server Management Studio for their database. FYI, they are using stored procedure as well. Thank you

Hi all, I'm not the best with coding and was wondering if some one can help me out. The page is inserting information into a database but when i added an extra section to insert i get the error [CODE] Could not find stored procedure 'Insert_PublicationsA'. Description: An unhandled exception …

Hello experts, My doubt is pretty simple, I suppose. But still I need assistance. I have a registration form as ASP.NET web form. There are 5-6 fields in it (username, password, email id, sex, country etc. ). I want to enter all the data, entered by a new user in …

i have code [CODE]Protected Sub btn_submitt_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_submitt.Click Try If (ddl_Country.SelectedItem.Text = "Select Country") Then Me.Label1.Visible = True Me.Label1.Text = "Please Select Country" Else Me.Label1.Visible = False Dim n As Int32 Dim connString As String = System.Configuration.ConfigurationManager.ConnectionStrings("containerConnectionString").ConnectionString Dim con As SqlConnection = New …

Hi, I am using visual basic express 2008 . and i am adding few rows to the database using some stored procedure. it is working fine. after adding the row i am displaying in a grid using dataset . fine.but when i close the program and reopen the program i …

Hello everyone. I have a php webpage, where there are textforms, dropdown lists and stuff. There is Activity field in the database. Whatever activities that i do on the webpage, like modifying the text in the textbox, or changing a value for a dropdown list, these need to be automatically …

I am writing an output stored procedure that i access using c#. I am trying to print the output values from the stored procedure. [code] using (SqlConnection connection = new SqlConnection(connectionstring)) { connection.Open(); SqlCommand emailcmdsql; emailcmdsql = new SqlCommand("returnemail", connection); emailcmdsql.CommandType = CommandType.StoredProcedure; SqlParameter paruser = emailcmdsql.Parameters.Add("@user", SqlDbType.VarChar); paruser.Value = …

Hi all, The problem here is, is there a way in which i call the output of 1 stored procedure inside another and display that in the 2nd procedure results..? Should we call a stored procedure inside a stored procedure for for this..? If so, wats the way..?

This is my Stored Procedure DELIMITER $$ [code=mysql] DROP PROCEDURE IF EXISTS `call`.`sp_login`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_login`(userid varchar(50),pass varchar(50),out chk int(11),out user_alias varchar(50),out user_tariff varchar(50),out c_credit decimal(15,5),out r_reseller varchar(10),out r_level varchar(10),out c_tariff char(2)) BEGIN select id into chk from cc_reseller where useralias =userid and uipass=pass and level!=0 and activated!='0'; if(chk!="") …