Comments by UDTWS (Top 27 by date)

protected void btn_insert_Click(object sender, EventArgs e)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
string path = string.Concat(Server.MapPath("~/UploadFile/" + fu_photo.FileName));
fu_photo.SaveAs(path);
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("spCreateUser", con);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("userName", txt_username.Text);
cmd.Parameters.AddWithValue("pass", txt_pass.Text);
cmd.Parameters.AddWithValue("email", txt_email.Text);
cmd.Parameters.AddWithValue("userRole", ddl_role.SelectedValue);
cmd.Parameters.AddWithValue("userPhoto", path);
cmd.Parameters.AddWithValue("userStatus", ddl_status.SelectedValue);
var result = cmd.Parameters.Add("@result", SqlDbType.Int);

returnParameter.Direction = ParameterDirection.ReturnValue;
con.Open();
int k = cmd.ExecuteNonQuery();
if (k != 0)
{
lblMsg.Text = "Record Inserted Succesfully into the Database";
lblMsg.ForeColor = System.Drawing.Color.CornflowerBlue;
}
con.Close();
}

now error is :-
The name 'returnParameter' does not exists in the current context.

Procedure or function 'spCreateUser' expects parameter '@result', which was not supplied.

i will store my password with encryption. and if not save in database than what should i do.

Thanks for reply,
but this code is not working due to not know how exact i use this sp. got error message you not pass result.

i am trying to pass value using postbackurl property of linkbutton. and hidden field value pass in another page. when i use this in new file working properly but where i really want to use not working their. for this any solution. even i try to pass static value from one page to another page in real page.

Thanks for reply but i would like to send values on another page. is it possible that we send values from one page to another page using View State.

is their any other process to pass values without using querysting or session.

is their any other process to pass values without using querysting or session.

is their any other process to pass values without using querysting or session.

no i create connection string using ur suggestion but i still problem not solved...

ya i use this and create connection with the help of this but still i got problem so please check my connection string and tell me where i am wrong..
thanks & regards

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Security.Cryptography;
using System.Text;
using System.Configuration;
using System.Data;

public partial class admin_Default : System.Web.UI.Page
{
// string conStr = ConfigurationManager.ConnectionStrings("WebConn").ConnectionString;
SqlConnection conStr = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)
{

}
public bool validation()
{
bool functionReturnValue = false;
if ((txtUserNm.Text.Trim().ToString()).Length <= 3 | (txtUserNm.Text.Trim().ToString()).Length > 10)
{
ltrlMsg.Text = "Enter correct Login ID";
var _with1 = txtUserNm;
if (_with1.Enabled & _with1.Visible)
_with1.Focus();
return false;
return functionReturnValue;
}
else if ((txtPassword.Text.Trim().ToString()).Length <= 3 | (txtPassword.Text.Trim().ToString()).Length > 10)
{
ltrlMsg.Text = "Enter correct Password";
var _with2 = txtPassword;
if (_with2.Enabled & _with2.Visible)
_with2.Focus();
return false;
//return functionReturnValue;
}
return true;
//return functionReturnValue;
}

public void infobox(string message)
{
string NewScript = null;
NewScript = "<script language=JavaScript>";
NewScript = NewScript + "alert('" + message + "');";
NewScript = NewScript + "</script" + ">";
if ((!ClientScript.IsClientScriptBlockRegistered("alert"))) {
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", NewScript);
}
}
private string md5(string sPassword)
{
System.Security.Cryptography.MD5CryptoServiceProvider x = new System.Security.Cryptography.MD5CryptoServiceProvider();
byte[] bs = System.Text.Encoding.UTF8.GetBytes(sPassword);
bs = x.ComputeHash(bs);
System.Text.StringBuilder s = new System.Text.StringBuilder();
foreach (byte b in bs)
{
s.Append(b.ToString("x2").ToLower());
}
return s.ToString();
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (validation() == true)
{
SqlCommand cmd = new SqlCommand();
string sql = "Select * from tblMN_Login where mnLoginId='" + txtUserNm.Text.Trim() + "'";
string pswd = null;
conStr.Open();
cmd.Connection = conStr;
cmd.CommandText = sql;
cmd.CommandType=System.Data.CommandType.Text;
SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read())
{
pswd=dr["mnPassword"].ToString();
if (pswd == md5(txtPassword.Text) )
{
ltrlMsg.Text = "";
Random rnd = new Random();
Session["authorise"] = rnd.Next(1000, 9999);
Session["LogId"] = txtUserNm.Text.Trim();
Session["UsrType"] = null;
if (Convert.ToInt32(dr["USER_TYPE"])== 11) {
Session["UsrType"] = 11;
Response.Redirect("SupLogin.aspx");
} else if (Convert.ToInt32(dr["USER_TYPE"]) == 27) {
Session["UsrType"] = 27;
Response.Redirect("MN_Login.aspx");
}
} else {
ltrlMsg.Text = "Wrong Password";
txtPassword.Focus();
}
} else {
ltrlMsg.Text = "Wrong Login ID";
txtUserNm.Focus();
}
if (conStr.State==System.Data.ConnectionState.Open)
conStr.Close();
}

}
}

Thanks for reply but still i got this error message...
Server Error in '/' Application.
WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for 'jquery'. Please add a ScriptResourceMapping named jquery(case-sensitive).
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.InvalidOperationException: WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for 'jquery'. Please add a ScriptResourceMapping named jquery(case-sensitive).

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for 'jquery'. Please add a ScriptResourceMapping named jquery(case-sensitive).]
System.Web.UI.ClientScriptManager.EnsureJqueryRegistered() +2170706
System.Web.UI.WebControls.BaseValidator.RegisterUnobtrusiveScript() +10
System.Web.UI.WebControls.BaseValidator.OnPreRender(EventArgs e) +9576593
System.Web.UI.Control.PreRenderRecursiveInternal() +83
System.Web.UI.Control.PreRenderRecursiveInternal() +168
System.Web.UI.Control.PreRenderRecursiveInternal() +168
System.Web.UI.Control.PreRenderRecursiveInternal() +168
System.Web.UI.Control.PreRenderRecursiveInternal() +168
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +974


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929

Thanks for reply but still i got same error

Thanks for reply
as you given solution i real a lot but i did not get answer so plz tell me that on my local host work properly but when i upload i got this error message and debug or do a lot will you explain what is the problem
Thanks & REgards

Thanks for reply and ya i know it but i just do it once to create database after that that page will be removed from server. plz tell me if any process thanks & regards

Thanks to reply but Mr.Wes Aday please understand my question first

Thanks for reply,
but i got an error msg like this DBNull is a type and cannot be used as an expression

Thanks for reply, i try this code to convert into string in if but error msg Conversion from string "" to type 'Bolean' is not valid

Thanks for solution. now i would like to know how i can close some toolbars.
Thanks again.

Sir i solve the problem and now file is uploading and i need work is done. is this write way to do this type of work. i want to know only that i am going to right direction or not. i think that my coding is too much poor.
Thanks for reply.
REgards
Umesh Daiya

Thanks For Reply: but plz check this
showimage.ashx

<%@ WebHandler Language="C#" Class="showimage" %>

using System;
using System.Web;
using System.Data.SqlClient;

public class showimage : IHttpHandler {

public void ProcessRequest(HttpContext context)
{
//establish the data connection
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["CONN_STRING"].ConnectionString))
{
//get the image through newsid passed as querystring
SqlCommand command = new SqlCommand("Select news_image from tbl_news where news_id = '" + context.Request.QueryString["newsid"] + "'", connection);

connection.Open();
SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
if (dr["news_image"].ToString().Length > 0)
{
context.Response.BinaryWrite((byte[])dr["news_image"]);
}
}
}
}
}
default.aspx
<pre lang="xml"><asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
BorderWidth="0" BorderColor="White" ShowHeader="False" Width="100%">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:HyperLink runat="server" ID="hl" NavigateUrl='<%#"NewsDetails.aspx?Newsid="+ Eval("news_id") %>' Text='<%# Eval("news_title") %>'></asp:HyperLink>
<img id="imgTest" src="showimage.ashx?newsid=<%# Eval("news_id=") %>" width="100px" height="100px" title="<%# Eval("news_title") %>" />
</img>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView></pre>

i do this as you suggested is it right. but i have got a error message "Error 26 showimage does not implement interface member System.Web.IHttpHandler.IsReusable.
"
now what i should do to correct this i use first time this handler i did not know about it more.