How to call a procedure in this code? Iam frustated with code .plz help.

Question

1.00/5 (1 vote)

See more:

, +

my .aspx file (doctorsignup.aspx)

ASP.NET

<%@ Page Language= "C# " MasterPageFile= "~/MasterPage.master " AutoEventWireup= "true " CodeFile= "doctorsignup.aspx.cs " Inherits= "doctorsignup " Title= "Untitled Page " % >
<asp:Content ID= "Content1 " ContentPlaceHolderID= "ContentPlaceHolder1 " Runat= "Server " >
    <asp:Label ID= "Label1 " runat= "server " Text= " Register Here  "
       style= "z-index: 100; left: 256px; position: absolute; top: 202px; width: 303px; "
       Font-Names= "Modern " Font-Size= "32pt " ForeColor= "Red " > </asp:Label >
    <table style= "z-index: 101; left: 234px; position: absolute; top: 275px; color: #ffffff; font-family:  'Lucida Console '; " >
    <tr > <td style= "height: 26px " >Name </td > <td style= "height: 26px " > <asp:TextBox ID= "nametxt " runat= "server " > </asp:TextBox > </td > <td style= "height: 26px; width: 157px; " >
        <asp:RequiredFieldValidator ID= "RequiredFieldValidator1 " runat= "server " ErrorMessage= "Enter Name "
           Style= "position: relative " ControlToValidate= "nametxt " >* </asp:RequiredFieldValidator > </td > </tr >
    <tr > <td >Login Id </td > <td > <asp:TextBox ID= "lidtxt " runat= "server " > </asp:TextBox > </td > <td style= "width: 157px " >
        <asp:RequiredFieldValidator ID= "RequiredFieldValidator2 " runat= "server " ErrorMessage= "Enter Login Id "
           Style= "position: relative " ControlToValidate= "lidtxt " >* </asp:RequiredFieldValidator > </td > </tr >

    <tr > <td >Password </td > <td > <asp:TextBox ID= "pwdtxt " runat= "server " > </asp:TextBox > </td > <td style= "width: 157px " >
        <asp:RequiredFieldValidator ID= "RequiredFieldValidator4 " runat= "server " ControlToValidate= "pwdtxt "
           ErrorMessage= "Enter Password " Style= "position: relative " >* </asp:RequiredFieldValidator > </td > </tr >
    <tr > <td >Confirm Password </td > <td > <asp:TextBox ID= "conpwdtxt " runat= "server " > </asp:TextBox > </td > <td style= "width: 157px " >
        <asp:CompareValidator ID= "CompareValidator1 " runat= "server " ControlToCompare= "pwdtxt "
           ControlToValidate= "conpwdtxt " ErrorMessage= "Not Matching " Style= "position: relative " >* </asp:CompareValidator > </td > </tr >
    <tr > <td >Department </td > <td >
        <asp:DropDownList ID= "depddl " runat= "server " Width= "153px " >
            <asp:ListItem >----Select---- </asp:ListItem >
            <asp:ListItem >Cardiology </asp:ListItem >
            <asp:ListItem >Neurology </asp:ListItem >
            <asp:ListItem >Opthalmology, </asp:ListItem >
            <asp:ListItem >Nephrology </asp:ListItem >
            <asp:ListItem >Surgery </asp:ListItem >
            <asp:ListItem >Pediatrics </asp:ListItem >
        </asp:DropDownList > </td > <td style= "width: 157px " >
            <asp:RequiredFieldValidator ID= "RequiredFieldValidator3 " runat= "server " ControlToValidate= "depddl "
               ErrorMessage= "Enter Your Department " Style= "position: relative " >* </asp:RequiredFieldValidator > </td > </tr >
    <tr > <td >Specialization </td > <td >
        <asp:DropDownList ID= "speddl " runat= "server " Width= "154px " >
            <asp:ListItem >----Select---- </asp:ListItem >
            <asp:ListItem >Pulmonology </asp:ListItem >
            <asp:ListItem >Cardiology </asp:ListItem >
            <asp:ListItem >Neurology </asp:ListItem >
            <asp:ListItem >Nephrology </asp:ListItem >
            <asp:ListItem >Opthalmology </asp:ListItem >
        </asp:DropDownList > </td > <td style= "width: 157px " >
            <asp:RequiredFieldValidator ID= "RequiredFieldValidator5 " runat= "server " ControlToValidate= "speddl "
               ErrorMessage= "Specialization " Style= "position: relative " >* </asp:RequiredFieldValidator > </td > </tr >
    <tr > <td >Phone Number </td > <td > <asp:TextBox ID= "phtxt " runat= "server " > </asp:TextBox > </td > <td style= "width: 157px " > </td > </tr >
    <tr > <td >Address </td > <td > <asp:TextBox ID= "addtxt " runat= "server " > </asp:TextBox > </td > <td style= "width: 157px " > </td > </tr >
    <tr > <td >E-Mail </td > <td > <asp:TextBox ID= "emtxt " runat= "server " > </asp:TextBox > </td > <td style= "width: 157px " >
        <asp:RegularExpressionValidator ID= "RegularExpressionValidator1 " runat= "server " ControlToValidate= "emtxt "
           ErrorMessage= "Incorrect Format " Style= "position: relative " ValidationExpression= "\w+([-+. ']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)* " >* </asp:RegularExpressionValidator > </td > </tr >
    </table >
    <table style= "z-index: 101; left: 299px; position: absolute; top: 549px; font-weight: bold; color: #ffffff; font-family:  'Lucida Console '; " >
    <tr > <td style= "width: 88px " >
        <asp:Button ID= "subbtn " runat= "server " Text= "Submit " Width= "94px " OnClick= "subbtn_Click " / > </td >
        <td style= "width: 93px " >
        <asp:Button ID= "Resbtn " runat= "server " Text= "Reset " Width= "94px " OnClick= "Resbtn_Click " / > </td >
     <td style= "width: 93px " >
        <asp:Button ID= "canbtn " runat= "server " Text= "Cancel " Width= "94px " OnClick= "canbtn_Click " / > </td > </tr >
    </table >
</asp:Content >

.aspx.cs file (doctorsignup.aspx.cs)

C#

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class doctorsignup : System.Web.UI.Page
{
   // this is already written code should replace if the code wont work below) SqlConnection cn = new SqlConnection(@&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Angel\Desktop\Hospital Management System ASP.NET Project\Hospital Management System Source Code\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True&quot;);
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected virtual void subbtn_Click(object sender, EventArgs e)
    {
        // this is for above database connection)//cn.Open();

        try
        {
            SqlConnection cn = new SqlConnection(@&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Angel\Desktop\Hospital Management System ASP.NET Project\Hospital Management System Source Code\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True&quot;);
            SqlCommand command = new SqlCommand(&quot;sp_hospital_doctorsignup&quot;, cn);
            command.CommandType = CommandType.StoredProcedure;
            command.Parameters.Add(&quot;@name&quot;,SqlDbType.VarChar,20).Value = nametxt.Text;
            command.Parameters.Add(&quot;@loginid&quot;,SqlDbType.VarChar,20).Value = lidtxt.Text;
            command.Parameters.Add(&quot;@password&quot;,SqlDbType.VarChar,20).Value = pwdtxt.Text;
            command.Parameters.Add(&quot;@department&quot;,SqlDbType.VarChar,20).Value = depddl.Text;
            command.Parameters.Add(&quot;@specialization&quot;,SqlDbType.VarChar,20).Value = speddl.Text;
            command.Parameters.Add(&quot;@phonenumber&quot;, SqlDbType.BigInt).Value = phtxt.Text;
            command.Parameters.Add(&quot;@address&quot;,SqlDbType.VarChar,40).Value = addtxt.Text;
            command.Parameters.Add(&quot;@email&quot;,SqlDbType.VarChar,20).Value = emtxt.Text;            
            cn.Open();
            return command.ExecuteNonQuery();
            cn.Close();
        }
        catch (SqlException ex)
        {
            Console.WriteLine(&quot;SQL Error&quot; + ex.Message.ToString());
            return 0;
            
        }

// the below code is written by me to the stored procedure .its going o stored procedure but its not calling the procedure .so am modifying this block of code with the other code and for a rference am keeeping the below code from here to emtxt in comment lines

C#

        /*SqlCommand cmd =new SqlCommand(&quot;sp_hospital_doctorsignup&quot;, cn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(&quot;@name&quot;, nametxt);
        cmd.Parameters.Add(&quot;@loginid&quot;, lidtxt);
        cmd.Parameters.Add(&quot;@password&quot;, pwdtxt);
        cmd.Parameters.Add(&quot;@department&quot;, depddl);
        cmd.Parameters.Add(&quot;@specialization&quot;, speddl);
        cmd.Parameters.Add(&quot;@phonenumber&quot;, phtxt);
        cmd.Parameters.Add(&quot;@address&quot;, addtxt);
        cmd.Parameters.Add(&quot;@email&quot;, emtxt);   */         // this is my code 
       /* SqlCommand cmd = new SqlCommand();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = &quot;sp_hospital_doctorsignup&quot;;
        cmd.Connection = cn;


        SqlParameter name  = new SqlParameter(&quot;@name&quot;, SqlDbType.VarChar, 20);
        name.Value = nametxt.Text;
        cmd.Parameters.Add(name);

        SqlParameter loginid = new SqlParameter(&quot;@loginid&quot;, SqlDbType.VarChar, 20);
        loginid.Value = lidtxt.Text;
        cmd.Parameters.Add(loginid);

        SqlParameter password = new SqlParameter(&quot;@password&quot;, SqlDbType.VarChar, 20);
        password.Value = pwdtxt.Text;
        cmd.Parameters.Add(password);

        SqlParameter department = new SqlParameter(&quot;@department&quot;, SqlDbType.VarChar, 20);
        department.Value = depddl.Text;
        cmd.Parameters.Add(department);

        SqlParameter specialization = new SqlParameter(&quot;@specialization&quot;, SqlDbType.VarChar, 20);
        specialization.Value = speddl.Text;
        cmd.Parameters.Add(specialization);

        SqlParameter phonenumber = new SqlParameter(&quot;@phonenumber&quot;, SqlDbType.BigInt);
        phonenumber.Value = phtxt.Text;
        cmd.Parameters.Add(phonenumber);

        SqlParameter address = new SqlParameter(&quot;@address&quot;, SqlDbType.VarChar, 40);
        address.Value = addtxt.Text;
        cmd.Parameters.Add(address);

        SqlParameter email = new SqlParameter(&quot;@email&quot;, SqlDbType.VarChar, 20);
        email.Value = emtxt.Text;
        cmd.Parameters.Add(email);*/

        //cmd.ExecuteNonQuery();
        
       //this my previous code line// cn.Close();
        Response.Redirect(&quot;doctorlogin.aspx&quot;);

    }
    protected void Resbtn_Click(object sender, EventArgs e)
    {
        Response.Redirect(&quot;doctorsignup.aspx&quot;);
    }
    protected void canbtn_Click(object sender, EventArgs e)
    {
        Response.Redirect(&quot;doctorlogin.aspx&quot;);
    }
}

the stored procedure i used here is
sp_hospital_doctorsignup

SQL

ALTER PROCEDURE dbo.sp_hospital_doctorsignup
(
@name varchar(20),
@loginid varchar(20),
@password varchar(20),
@department varchar(20),
@specialization varchar(20),
@phonenumber bigint,
@address varchar(40),
@email varchar(20)
)
as
begin
SET NOCOUNT ON;
begin
insert into hospital_doctorsignup values(@name,@loginid,@password,@department,@specialization,@phonenumber,@address,@email)
end
end

the table i created

hospital_doctorsignup

Table For Doctor Register

SQL

create table hospital_doctorsignup
(
 name varchar(20), 
 loginid varchar(20),
 password varchar(20),
 department varchar(20),
 specialization varchar(20),
 phonenumber bigint,
 address varchar(20),
 email varchar(20)
)

friends i had tried lot of blocks f code from code project itself but no one specified the entire code and am a beginner and am quite confused with this code .as u may see in comment lines i had written that its my code .by using that code am able to call the procedure but am not able to store the procedure .when i insert the values in registration form its redirecting me to the doctors login page but its not storing any values in the respective connected table which i had mentioned in the sp_hospital_doctorsignup stored procedure .i want to read the user inputs into the stored procedure .please help me to complete my project .if u wan me to mail my project to u am happy to do that but i want solution before 1st june 2016.please help me friends jus set a page for me .i will try to set other pages.
if u r setting the page plz mention the use of code in the comment line in each line of code.its a request.thanks in advance .thank you

What I have tried:

friends i had tried almost everything but am unable to place the block of code at right place.if u can plz set this page so i can execute the stored procedure and the values into my table hospital_doctorsignup.

Posted 28-May-16 23:48pm

Sheerin Shaik

Updated 29-May-16 1:04am

Patrice T

v3

Add a Solution

Comments

George Jonsson 29-May-16 5:59am

I tried to format the code, but the first part is a mess. You have to paste it again, I think.

Patrice T 29-May-16 6:21am

reformatted first part

George Jonsson 29-May-16 6:29am

Why do you post your code here in the comment section?

George Jonsson 29-May-16 6:38am

Use Improve question and either add new code or replace existing.

Sheerin Shaik 29-May-16 6:43am

can u fix the problem?

Sheerin Shaik 29-May-16 6:58am

may b i cant, coz thats my exact problem.i want to link the stored procedure to my page doctorsignup.aspx.cs and store the values in the tab;e which i had mentioned above .

Sheerin Shaik 29-May-16 7:09am

could you plz send me like i had posted here the entire page
coz it might be helpful am still in confusion wher ei shud place this .and my u had refered to my procedure?

Patrice T 29-May-16 6:53am

Use Improve question to update your question.

Sheerin Shaik 29-May-16 6:56am

at which part i should replace?

George Jonsson 29-May-16 7:00am

How would I know?
It is your code after all.
I am just saying that you should not post code in the comment section.

Sheerin Shaik 29-May-16 6:38am

what u meant by first part is mess? its well nd good there

George Jonsson 29-May-16 6:39am

It was a mess before ppolymorphe fixed it.

Sheerin Shaik 29-May-16 6:42am

k

Sheerin Shaik 29-May-16 6:45am

can u fix this code

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

George Jonsson · Answer 1 · 2016-05-29T01:04:00

Solution 1

Not sure which code block you want to keep, so I used the uncommented code.

1. You should always use the using statement, as it will close the connection automatically or use try-catch-finally
2. You forgot to assign the CommandText property
3. You have an integer type in your parameter list, but you assign a string.
It is good practice to use the proper type.

[UPDATE] Change to try-catch-finally instead of using

C#

SqlConnection cn = null;
try
{
    cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Angel\Desktop\Hospital Management System ASP.NET Project\Hospital Management System Source Code\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True")

    SqlCommand command = new SqlCommand("sp_hospital_doctorsignup", cn);
    command.CommandType = CommandType.StoredProcedure;
    command.CommandText = "sp_hospital_doctorsignup";
    command.Parameters.Add("@name",SqlDbType.VarChar,20).Value = nametxt.Text;
    command.Parameters.Add("@loginid",SqlDbType.VarChar,20).Value = lidtxt.Text;
    command.Parameters.Add("@password",SqlDbType.VarChar,20).Value = pwdtxt.Text;
    command.Parameters.Add("@department",SqlDbType.VarChar,20).Value = depddl.Text;
    command.Parameters.Add("@specialization",SqlDbType.VarChar,20).Value = speddl.Text;
    command.Parameters.Add("@phonenumber", SqlDbType.BigInt).Value = long.Parse(phtxt.Text);
    command.Parameters.Add("@address",SqlDbType.VarChar,40).Value = addtxt.Text;
    command.Parameters.Add("@email",SqlDbType.VarChar,20).Value = emtxt.Text;
    
    cn.Open();
    command.ExecuteNonQuery(); // Nothing to return. Right?

    // this code would never be called in your original code and with the using statement
    // it is not necessary
    // cn.Close(); 
}
catch (Exception ex)
{
    // Do error handling
}
finally
{
    if (cn != null)
        cn.Close();
}

End note
If you have a dead line, it is your concern. Don't add that in your question.
Also try to use proper writing, like using punctuation and start a sentence with a capital letter.

Posted 29-May-16 1:04am

George Jonsson

Updated 29-May-16 1:45am

v3

Comments

Sheerin Shaik 29-May-16 7:12am

could you plz make it little bit clear by mailing me the entire page on happylearning786@gmail.com ? it will be very helpful

George Jonsson 29-May-16 7:14am

You have a subbtn_Click method. I thought you wanted the code there.

Sheerin Shaik 29-May-16 7:29am

doctorsignup.command is a field but it is used like a type

Sheerin Shaik 29-May-16 7:15am

its not working i kept at first place

George Jonsson 29-May-16 7:22am

What is not working? Isn't the method called when you click the button?

Sheerin Shaik 29-May-16 7:30am

it is prompting that when i keep cursor there .am working with visual web developer express

Sheerin Shaik 29-May-16 7:32am

its not recognising using( line

Sheerin Shaik 29-May-16 7:33am

using (SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Angel\Desktop\Hospital Management System ASP.NET Project\Hospital Management System Source Code\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True"))

its not recognising it .it showing that its wrong

George Jonsson 29-May-16 7:46am

See my updated answer.
Instead of using, you can use try-catch-finally. It is basically the same thing

Sheerin Shaik 29-May-16 7:34am

if you dont mind could you plz mail me the whole page/code on my mail id :(happylearning786@gmail.com): ? plz

George Jonsson 29-May-16 7:48am

I mind.

Sheerin Shaik 29-May-16 8:23am

Server Error in '/Hospital Management System Source Code' Application.

Input string was not in a correct format.

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.FormatException: Input string was not in a correct format.

Source Error:

Line 35:
Line 36: cn.Open();
Line 37: command.ExecuteNonQuery(); // Nothing to return. Right?
Line 38:
Line 39: // this code would never be called in your original code and with the using statement

Source File: c:\Users\Angel\Desktop\Hospital Management System Source Code\doctorsignup.aspx.cs Line: 37

Stack Trace:

[FormatException: Input string was not in a correct format.]
System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +11013491
System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt) +156
System.String.System.IConvertible.ToInt64(IFormatProvider provider) +48
System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) +10785804
System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) +5333855

[FormatException: Failed to convert parameter value from a String to a Int64.]
System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) +5332847
System.Data.SqlClient.SqlParameter.GetCoercedValue() +185
System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) +102
System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) +122
System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc) +78
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +208
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +163
doctorsignup.subbtn_Click(Object sender, EventArgs e) in c:\Users\Angel\Desktop\Hospital Management System Source Code\doctorsignup.aspx.cs:37
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9628442
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

this is the error now .could u plz tell me if u no watshappening/

Sheerin Shaik 29-May-16 8:23am

do u hav any solution for this?

George Jonsson 29-May-16 8:34am

Seems I was wrong with this line
command.Parameters.Add("@phonenumber", SqlDbType.BigInt).Value = long.Parse(phtxt.Text);
change back to
command.Parameters.Add("@phonenumber", SqlDbType.BigInt).Value = phtxt.Text;
The conversion is done automatically, if I understood the documentation correctly.

Sheerin Shaik 29-May-16 8:49am

i had tried that too after trying ttat i got this error

George Jonsson 29-May-16 8:55am

Then check the value of phtxt.Text in the debugger.
Is it really an integer value?

Sheerin Shaik 29-May-16 8:53am

i think there might be something like command.ExecuteReader ,DataReader,DataAdapter or ds.fill should be used or if (!page.IsPostBack) should be used .will u suggest me something from this

Sheerin Shaik 29-May-16 8:56am

yes i kept it as bigint

George Jonsson 29-May-16 8:59am

What is the value in the text box?

Sheerin Shaik 29-May-16 9:55am

phtxt

George Jonsson 29-May-16 9:59am

The value of phtxt.Text, not the name of the text box.
If the value really is 'phtext' then of course the conversion from a string to a number will fail.

Sheerin Shaik 29-May-16 9:58am

iam afraid to say this,but i jus added deadline coz someone can know my situation to a little bit and take a step forward to help me and except this i dint mean anything by adding a deadine there .and thankyou for taking a step ahead for helping me :)

Sheerin Shaik 29-May-16 10:00am

there is the same code as i mentioned here.and there are that values only .I request u to post the entire code in the comment with ur suggested code .coz am little bit confused by reading lot of articles related to that.infact am confused with my own code now so plz consider it and send me the whole c# page here itself.thanks in advance .thankyou

George Jonsson 29-May-16 10:10am

I am not going to setup your whole system and debug it for you, so I cannot send you the complete code.
You get the exception [FormatException: Input string was not in a correct format.], most likely because the value of phtxt.Text is not a number, like 12345467, but contains some non-numerical characters or is empty.
Use the debugger and set a breakpoint and inspect the value, or at least look in your form what value you enter in that text box.

Sheerin Shaik 29-May-16 10:32am

Iam afraid to say this ,but i havnt asked you to set the whole system for me .in my project there are 30 pages to set and i had created almost 8+ procedures and few tables at my own .i dont know the .net .thats the biggest thing making me feel low .even i dont know .net am trying to workout by refering articles and lot more stuff which i found at google. u know wats the biggest problem am facing? the code snippets .iam able to understand the snippets but am unable to place them at right place .now also u given me a block of code and i dont know where to place it.i had placed right next to my button syntax but unfortunately in my code there is a connection open on the above of button syntax and am confused whether it should be there or not? should i open any other connection to work other buttons or shud i close? am i doing it in a right way r not ? these r the questions going in my mind.i jus asked u for a page .that too when i noticed may b it can work . u were quite confident about ur code .so i thought may b u might help me to understand it in a better way.i just requested for a doctorsignup.aspx.cs file for the reference coz i hav to work on my project basing on the code you give me here and while coming to point of exception i wanna show u something here

Error 1 Invalid token '(' in class, struct, or interface member declaration C:\Users\Angel\Desktop\Hospital Management System Source Code\doctorsignup.aspx.cs 44 16 C:\...\Hospital Management System Source Code\

Error 2 Invalid token '=' in class, struct, or interface member declaration C:\Users\Angel\Desktop\Hospital Management System Source Code\doctorsignup.aspx.cs 73 29 C:\...\Hospital Management System Source Code\

Error 3 Invalid token ';' in class, struct, or interface member declaration C:\Users\Angel\Desktop\Hospital Management System Source Code\doctorsignup.aspx.cs 73 58 C:\...\Hospital Management System Source Code\
Error 3 Invalid token ';' in class, struct, or interface member declaration C:\Users\Angel\Desktop\Hospital Management System Source Code\doctorsignup.aspx.cs 73 58 C:\...\Hospital Management System Source Code\
Error 3 Invalid token ';' in class, struct, or interface member declaration C:\Users\Angel\Desktop\Hospital Management System Source Code\doctorsignup.aspx.cs 73 58 C:\...\Hospital Management System Source Code
am getting exceptions like this and i dont find anyerror there .
finally ,thankyou for help me .its pleasure working with u .

Sheerin Shaik 29-May-16 10:33am

onemore thing thanks for letting me know abt the phtxt textbox .i had set it to bigint and now i will edit it to varchar .thanks once again .happy times upon u takecare:)

How to call a procedure in this code? Iam frustated with code .plz help.

1 solution

Solution 1

Add your solution here

Preview 0

How to call a procedure in this code? Iam frustated with code .plz help.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us