Click here to Skip to main content
15,921,697 members
Home / Discussions / C#
   

C#

 
GeneralRequired permissions cannot be acquired Pin
Daniel Zaharia22-Jun-04 23:25
Daniel Zaharia22-Jun-04 23:25 
GeneralRe: Required permissions cannot be acquired Pin
Jochen Kalmbach [MVP VC++]23-Jun-04 0:44
Jochen Kalmbach [MVP VC++]23-Jun-04 0:44 
GeneralRe: Required permissions cannot be acquired Pin
Daniel Zaharia23-Jun-04 1:37
Daniel Zaharia23-Jun-04 1:37 
GeneralRe: Required permissions cannot be acquired Pin
Jochen Kalmbach [MVP VC++]23-Jun-04 1:57
Jochen Kalmbach [MVP VC++]23-Jun-04 1:57 
GeneralRe: Required permissions cannot be acquired Pin
Heath Stewart23-Jun-04 4:19
protectorHeath Stewart23-Jun-04 4:19 
GeneralRe: Required permissions cannot be acquired Pin
Daniel Zaharia23-Jun-04 4:37
Daniel Zaharia23-Jun-04 4:37 
GeneralRe: Required permissions cannot be acquired Pin
Daniel Zaharia23-Jun-04 2:06
Daniel Zaharia23-Jun-04 2:06 
GeneralRegistration page woes Pin
diptea22-Jun-04 23:18
diptea22-Jun-04 23:18 
Can some1 pls tell me what's wrong with my coding? thank u.


<%@ Page Language="C#" Debug="True" %>


int AddUser(string fname, string sname, string username, string password)
{
string connectionString = "server=\'\'; user id=\'\'; password=\'\'; databas" +
"e=\'\'";
System.Data.IDbConnection dbConnection = new System.Data.SqlClient.SqlConnection(connectionString);

string queryString = "INSERT INTO [Members] ([fname], [sname], [username], [password]) VALUES (@fname, " +
"@sname, @username, @password)";
System.Data.IDbCommand dbCommand = new System.Data.SqlClient.SqlCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;

System.Data.IDataParameter dbParam_fname = new System.Data.SqlClient.SqlParameter();
dbParam_fname.ParameterName = "@fname";
dbParam_fname.Value = fname;
dbParam_fname.DbType = System.Data.DbType.String;
dbCommand.Parameters.Add(dbParam_fname);
System.Data.IDataParameter dbParam_sname = new System.Data.SqlClient.SqlParameter();
dbParam_sname.ParameterName = "@sname";
dbParam_sname.Value = sname;
dbParam_sname.DbType = System.Data.DbType.String;
dbCommand.Parameters.Add(dbParam_sname);
System.Data.IDataParameter dbParam_username = new System.Data.SqlClient.SqlParameter();
dbParam_username.ParameterName = "@username";
dbParam_username.Value = username;
dbParam_username.DbType = System.Data.DbType.String;
dbCommand.Parameters.Add(dbParam_username);
System.Data.IDataParameter dbParam_password = new System.Data.SqlClient.SqlParameter();
dbParam_password.ParameterName = "@password";
dbParam_password.Value = password;
dbParam_password.DbType = System.Data.DbType.String;
dbCommand.Parameters.Add(dbParam_password);

int rowsAffected = 0;
dbConnection.Open();
try {
rowsAffected = dbCommand.ExecuteNonQuery();
}
finally {
dbConnection.Close();
}

return rowsAffected;
}

void Button1_Click(object sender, EventArgs e)
{
if AddUser(txtUserName.Text, txtUserPassword.Text) > 0
Message.Text = "Success";
else
Message.Text = "Failure";


}








<asp:label id="Label1" runat="server">User Name 
<asp:textbox id="txtUserName" runat="server">



<asp:label id="Label2" runat="server">Password 
<asp:textbox id="txtUserPassword" runat="server" textmode="Password">



<asp:label id="Message" runat="server">



<asp:button id="Button1" onclick="Button1_Click" runat="server" text="Register">





GeneralRe: Registration page woes Pin
Colin Angus Mackay22-Jun-04 23:39
Colin Angus Mackay22-Jun-04 23:39 
GeneralTo add a style in datagrid Pin
HowRU22-Jun-04 23:05
HowRU22-Jun-04 23:05 
GeneralRe: To add a style in datagrid Pin
Dave Kreskowiak23-Jun-04 4:05
mveDave Kreskowiak23-Jun-04 4:05 
GeneralA question about VBA and C# Pin
Member 94012522-Jun-04 22:34
Member 94012522-Jun-04 22:34 
GeneralRe: A question about VBA and C# Pin
Heath Stewart23-Jun-04 4:06
protectorHeath Stewart23-Jun-04 4:06 
GeneralQ: Coloring Schemes Pin
yoaz22-Jun-04 22:08
yoaz22-Jun-04 22:08 
GeneralRe: Q: Coloring Schemes Pin
Daniel M. Edwards23-Jun-04 3:02
Daniel M. Edwards23-Jun-04 3:02 
GeneralRe: Q: Coloring Schemes Pin
yoaz23-Jun-04 4:29
yoaz23-Jun-04 4:29 
Questionhow to add a style in datagrid Pin
HowRU22-Jun-04 21:46
HowRU22-Jun-04 21:46 
AnswerRe: how to add a style in datagrid Pin
dabuskol22-Jun-04 23:42
dabuskol22-Jun-04 23:42 
Generalmove AxPdfLib.AxPdf Pin
fatidarya22-Jun-04 21:29
fatidarya22-Jun-04 21:29 
GeneralRe: move AxPdfLib.AxPdf Pin
Heath Stewart23-Jun-04 3:19
protectorHeath Stewart23-Jun-04 3:19 
GeneralRe: move AxPdfLib.AxPdf Pin
fatidarya25-Jun-04 19:02
fatidarya25-Jun-04 19:02 
GeneralRe: move AxPdfLib.AxPdf Pin
Heath Stewart26-Jun-04 13:59
protectorHeath Stewart26-Jun-04 13:59 
Generalserializing userControl BackGroundimage Pin
fatidarya22-Jun-04 21:06
fatidarya22-Jun-04 21:06 
GeneralRe: serializing userControl BackGroundimage Pin
Heath Stewart22-Jun-04 21:12
protectorHeath Stewart22-Jun-04 21:12 
GeneralRe: serializing userControl BackGroundimage Pin
fatidarya22-Jun-04 21:54
fatidarya22-Jun-04 21:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.