Advertisement
Advertisement
| 06.25.2008 at 05:13AM PDT, ID: 23514115 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: |
ALTER PROCEDURE dbo.StoredProcedure1
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
@EventId varchar(50),
@UserId varchar(50),
@CatId varchar(50),
@EventName varchar(50),
@Organiser varchar(50),
@ContactEmail varchar(50),
@ShortText varchar(50),
@LongText varchar(50),
@Address varchar(50),
@City char(30),
@Price Money,
@Thumbnail varchar(20),
@eImage varchar(20),
@eDate datetime,
@eTime varchar(10),
@Venue varchar(50),
@Tickets varchar(50),
@Age char(10)
AS
INSERT INTO Events
(EventId, UserId, CatId, EventName, Organiser, ContactEmail, ShortText, LongText, Address, City, Price, Thumbnail, eImage, eDate, eTime, Venue, Tickets, Age)
/* SET NOCOUNT ON */
VALUES(@EventId, @UserId, @CatId, @EventName, @Organiser, @ContactEmail, @ShortText, @LongText, @Address, @City, @Price, @Thumbnail, @eImage, @eDate, @eTime, @Venue, @Tickets, @Age)
RETURN
/////////////////////////////////////////////////
public partial class AddEvent : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MembershipUser myObject = Membership.GetUser();
string UserID = myObject.ProviderUserKey.ToString();
Label6.Text = UserID;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("StoredProcedure1 ", new SqlConnection(ConfigurationManager.AppSettings["ConnString"]));
cmd.CommandType = CommandType.StoredProcedure;
/*cmd.Parameters.AddWithValue("@UserID", UserID);*/
cmd.Parameters.AddWithValue("@EventName", eName.Text);
cmd.Parameters.AddWithValue("@city", Organiser.Text);
cmd.Parameters.AddWithValue("@ContactEmail", ContactEmail.Text);
cmd.Parameters.AddWithValue("ShortText", Short.Text);
cmd.Parameters.AddWithValue("@LongText", Long.Text);
cmd.Parameters.AddWithValue("@Address", Address.Text);
cmd.Parameters.AddWithValue("@City", City.Text);
cmd.Parameters.AddWithValue("@Price", Price.Text);
cmd.Parameters.AddWithValue("@eDate", Date.Text);
cmd.Parameters.AddWithValue("@eTime", Time.Text);
cmd.Parameters.AddWithValue("@Venue", Venue.Text);
cmd.Parameters.AddWithValue("@Tickets", Tickets.Text);
/*cmd.Parameters.AddWithValue("@Age", Age.SelectedIndex.ToString);*/
/*cmd.Parameters.AddWithValue("@name", txtName.Text);
cmd.Parameters.AddWithValue("@city", txtCity.Text);
cmd.Parameters.AddWithValue("@name", txtName.Text);
cmd.Parameters.AddWithValue("@city", txtCity.Text);*/
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
}
////////////////////////////////////////////////////
</system.web.extensions>
<connectionStrings>
<add name ="ASPNETDBConnectionString1" connectionString ="Data Source= .\SQLEXPRESS; Integrated Security = True; Initial Catalog= ASPNETDB" providerName ="System.Data.SqlClient"/>
</connectionStrings>
<system.net>
<mailSettings>
<smtp>
<network host="localhost"/>
</smtp>
</mailSettings>
</system.net>
<system.webServer>
<validation validateIntegratedModeConfiguration="false"/>
<modules>
<add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</modules>
<handlers>
<remove name="WebServiceHandlerFactory-Integrated" />
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode"
type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode"
type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</handlers>
</system.webServer>
<appSettings>
<add key="ConnString" value="Data Source=.\SQLEXPRESS;Initial Catalog=ASPNETDB;Integrated Security=True"/>
</appSettings>
</configuration>
|