Comments by jayraj86 (Top 87 by date)

no error.. When i change image it gets updated but not other fields

I tried writing Response.write("text") in else section but it doesnt show on click. I have not chosen any file to upload here

thanks

no..but it changes the layout and doesn't show paging at bottom

tried it changes entire view of gridview.. which i dont want

yes i debugged..

I am getting this error on first line of GridView2_RowDataBound which is


string str = " Category :" +........

:) Not able to solve this other problem - http://www.codeproject.com/Questions/768674/Paging-in-gridview-Specified-argument-was-out-of-t see if you can solve

Got it. Thanks a lot!

Thanks a lot!!

Nothing happens when I select this last radio button ;/

Same thing i am loading in other page using same code and it works perfectly on other page

Same thing i am loading in other page using same code and it works perfectly on other page

here it is


protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
{
string str = " Category :" + e.Row.Cells[6].Text + "<br/>Duration :" + e.Row.Cells[4].Text + "<br/>InternshipCity :" + e.Row.Cells[5].Text + "<br/>Stipend :" + e.Row.Cells[7].Text + "<br/>InternshipStartDate :" + e.Row.Cells[2].Text + "<br/>ApplicationDeadline :" + e.Row.Cells[3].Text + "<br/>Required Degree :" + e.Row.Cells[9].Text + "<br/>Required Branch :" + e.Row.Cells[10].Text;
e.Row.Cells[1].Text = str;

//e.Row.Cells[1].Visible = false;
//e.Row.Cells[2].Visible = false;
e.Row.Cells[3].Visible = false;
e.Row.Cells[4].Visible = false;
e.Row.Cells[5].Visible = false;
e.Row.Cells[6].Visible = false;
e.Row.Cells[7].Visible = false;
e.Row.Cells[8].Visible = false;
e.Row.Cells[9].Visible = false;
e.Row.Cells[10].Visible = false;
e.Row.Cells[11].Visible = false;
e.Row.Cells[12].Visible = false;
e.Row.Cells[13].Visible = false;


if (GridView2.Rows.Count > 0)
{
GridView2.HeaderRow.Cells[0].Text = " ";
GridView2.HeaderRow.Cells[1].Text = " ";
GridView2.HeaderRow.Cells[2].Text = " ";




}
Image img = new Image();
img.ID = "abc";
img.ImageUrl = e.Row.Cells[0].Text;
e.Row.Cells[0].Controls.Add(img);

Button btn = new Button();
//btn.Text = "preview";
e.Row.Cells[2].Controls.Add(btn);
btn.CausesValidation = false;
btn.Text = "View and Apply";
if (Session.Count > 0)
{


btn.PostBackUrl = "Apply_internship.aspx?InternshipID=" + e.Row.Cells[8].Text + "&CompanyID=" + e.Row.Cells[11].Text + "&Title=" + e.Row.Cells[12].Text + "&CompanyName=" + e.Row.Cells[13].Text + "";
}

else
{

btn.PostBackUrl = "Apply_login.aspx";
}

}

I tried that also but I'm getting same error

I want to add a image between textbox and another image. like its in this link, on left side of email and password textbox.

Error: Control 'GridView2' does not implement IPageableItemContainer.

i'm getting this error "The data source does not support server-side data paging"

yes its returning

i applied that code..same error

protected void Recentinternship()
{
SqlConnection con = new SqlConnection("Data Source=jayraj-pc\\sqlexpress;Initial Catalog=Internship;Integrated Security=True;Pooling=False");
con.Open();
string str = "select B.CompanyLogo as ' ',A.Title,A.InternshipStartDate,A.ApplicationDeadline,A.Duration,A.InternshipCity,A.Category,A.Stipend,A.InternshipID,A.Degree,A.Branch,A.CompanyID,A.Title,A.CompanyName from Internship AS A INNER JOIN Companies AS B ON B.CompanyID=A.CompanyID ";
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
//SqlDataReader dr = cmd.ExecuteReader();
da.Fill(dt);
if (dt.Rows.Count > 0)
{

GridView2.DataSource = dt;
GridView2.DataBind();
}
//GridView2.BottomPagerRow.Visible = true;




con.Close();

}


I changed code to like this but the problem i am getting is no data is loding in gridview.

protected void Recentinternship()
{
SqlConnection con = new SqlConnection("Data Source=jayraj-pc\\sqlexpress;Initial Catalog=Internship;Integrated Security=True;Pooling=False");
con.Open();
string str = "select B.CompanyLogo as ' ',A.Title,A.InternshipStartDate,A.ApplicationDeadline,A.Duration,A.InternshipCity,A.Category,A.Stipend,A.InternshipID,A.Degree,A.Branch,A.CompanyID,A.Title,A.CompanyName from Internship AS A INNER JOIN Companies AS B ON B.CompanyID=A.CompanyID ";
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
//SqlDataReader dr = cmd.ExecuteReader();
da.Fill(dt);
if (dt.Rows.Count > 0)
{

GridView2.DataSource = dt;
GridView2.DataBind();
}
//GridView2.BottomPagerRow.Visible = true;




con.Close();

}


I changed code to like this but the problem i am getting is no data is loding in gridview.

done.. same error!

Same error

one other problem i m stuck at right now, can you sort it out ?
here is the link http://www.codeproject.com/Questions/756411/In-Asp-Net-Csharp-I-Have-Four-Dropdownlist-And-I-W

Yeah I got it later about that cmd thing, btw thank you so much RaajKumar :))

one other problem i m stuck at right now, can you sort it out ?
here is the link http://www.codeproject.com/Questions/756411/In-Asp-Net-Csharp-I-Have-Four-Dropdownlist-And-I-W

Thanks a lot. I never thought about that :)

Thanks a lot RaajKumar. it was just a small mistake, cmd2 instead of cmd in 3rd last line.

Thanks a lot RaajKumar. it was just a small mistake, cmd2 instead of cmd in 3rd last line :)

yes its filling gridview

yes its filling gridview

Yes its gridview is filling with userid and firstname

not working

I checked it by writing Response.Write("dfd"); below da.Fill(dt);
and its showing dfd at corner

i removed ... from insert query. no I'm not getting any error.

qlConnection con = new SqlConnection("Data Source=jayraj-pc\\sqlexpress;Initial Catalog=Internship;Integrated Security=True;Pooling=False");

con.Open();
SqlCommand cmd = new SqlCommand("select UserID,FirstName from Users where UserID='" + Session["UserID"].ToString() + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
SqlCommand cmd2 = new SqlCommand("insert into UsersApplied values('" + dt.Rows[0][0].ToString() + "','" + dt.Rows[0][1].ToString() + "',......) ", con);
cmd.ExecuteNonQuery();
}
con.Close();


I applied this code but i m not getting any data in AppliedUsers table. why ?

Appreciate your answer Raajkumar,
how can I write insert query here ?
INSERT INTO UsersApplied (UserID,FirstName)Values (???)
what should i write in values ??

I have tables
1.Users
2.AppliedUsers

in AppliedUsers table I have few 6-7 columns which are same as in Users table. As I want those values from Users table and store those values in this new AppliedUsers table.

I have stored UserID (from users table) value in session, the thing I am doing here is on button click i want to store selected values from Users into AppliedUsers table where UserId=session[userid]. The user is applying for job on button click and i want to store the data of that user who applied into this new AppliedUsers table from Users table.

This is my on button click code what changes should i make in this code ??

SqlConnection con = new SqlConnection("Data Source=jayraj-pc\\sqlexpress;Initial Catalog=Internship;Integrated Security=True;Pooling=False");
con.Open();
//if (Degree2.SelectedIndex > 0 && branch2.SelectedIndex > 0 && DropDownList1.SelectedIndex > 0 && DropDownList2.SelectedIndex > 0)
//{
string str = "select B.CompanyLogo as ' ',A.Title,A.InternshipStartDate,A.ApplicationDeadline,A.Duration,A.InternshipCity,A.Category,A.Stipend,A.InternshipID,A.Degree,A.Branch from Internship AS A INNER JOIN Companies AS B ON A.CompanyID=B.CompanyID where (Degree='" + Degree2.SelectedItem.Text + "' and Branch='" + branch2.SelectedItem.Text + "') or InternshipCity ='" + DropDownList1.SelectedItem.Text + "' or Category='" + DropDownList2.SelectedItem.Text + "'";
Response.Write(str);
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
SqlDataReader dr = cmd.ExecuteReader();



GridView2.DataSource = dr;
GridView2.DataBind();

//Response.Write(GridView2.Columns.Count.ToString());
con.Close();

can you please provide code for this ?

I saw 2nd link but i have not used stored procedure,I used default sql server of visual studio. so what changes i should made in that code ?

I am already loading it on !IsPostBack

string i checked, its okay. I am not having problem in cascading dropdownlist. the problem is in loadinternshipdata() function. where i am just loading data from table (editing profile, which shows all registered data in respective textboxes).

actually it is degree and branch in place of country and city

protected void BindDegreedropdown()
{
//conenction path for database
SqlConnection con = new SqlConnection("Data Source=jayraj-pc\\sqlexpress;Initial Catalog=Internship;Integrated Security=True;Pooling=False");
con.Open();
SqlCommand cmd = new SqlCommand("select * from Degree", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
DropDownList3.DataSource = ds;
DropDownList3.DataTextField = "DegreeName";
DropDownList3.DataValueField = "DegreeID";
DropDownList3.DataBind();
DropDownList3.Items.Insert(0, new ListItem("--Select--", "0"));
//branch1.Items.Insert(0, new ListItem("--Select--", "0"));

}


protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
int DegreeID = Convert.ToInt32(DropDownList3.SelectedValue);
SqlConnection con = new SqlConnection("Data Source=jayraj-pc\\sqlexpress;Initial Catalog=Internship;Integrated Security=True;Pooling=False");
con.Open();
SqlCommand cmd = new SqlCommand("select * from Branch where DegreeID=" + DegreeID, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
DropDownList4.DataSource = ds;
DropDownList4.DataTextField = "BranchName";
DropDownList4.DataValueField = "BranchID";
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, new ListItem("--Select--", "0"));
//if (DropDownList2.SelectedValue == "0")
//{
// DropDownList3.Items.Clear();
// DropDownList3.Items.Insert(0, new ListItem("--Select--", "0"));
//}
}

YES "show sub-menu on hover". i want the same using CSS

the case here is the user who get's logged in only his/her photo should be displayed.

My code is as below. I just want to display image on page load. i am using image control. what changes i should make in this code ?

protected void Page_Load(object sender, EventArgs e)
{

if (Convert.ToInt16(Session["CompanyID"].ToString()) > 0)
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from Companies where CompanyID=" + Session["CompanyID"], con);
SqlDataAdapter da = new SqlDataAdapter(cmd);


DataSet ds = new DataSet();

da.Fill(ds, "Companies");

if (ds.Tables[0].Rows.Count > 0)
{
email.Text = ds.Tables[0].Rows[0]["EmailID"].ToString();
firstname.Text = ds.Tables[0].Rows[0]["FirstName"].ToString();
lastname.Text = ds.Tables[0].Rows[0]["LastName"].ToString();
designation.Text = ds.Tables[0].Rows[0]["Designation"].ToString();
mobile.Text = ds.Tables[0].Rows[0]["ContactNo"].ToString();


Label9.Text = ds.Tables[0].Rows[0]["CompanyName"].ToString();
Label10.Text = ds.Tables[0].Rows[0]["City"].ToString();
Label16.Text = ds.Tables[0].Rows[0]["Address"].ToString();
Label11.Text = ds.Tables[0].Rows[0]["Website"].ToString();
Label12.Text = ds.Tables[0].Rows[0]["CompanyCategory"].ToString();
Label13.Text = ds.Tables[0].Rows[0]["NoOfEmployees"].ToString();
Label15.Text = ds.Tables[0].Rows[0]["Aboutcompany"].ToString();

}
}
}
}
}

Thanks.. but I am using session so I want image as per session id.

I have added image control.. will you please write that in code ?

My code is as below. I just want to display image on page load. i am using image control. what changes i should make in this code ?

protected void Page_Load(object sender, EventArgs e)
{

if (Convert.ToInt16(Session["CompanyID"].ToString()) > 0)
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from Companies where CompanyID=" + Session["CompanyID"], con);
SqlDataAdapter da = new SqlDataAdapter(cmd);


DataSet ds = new DataSet();

da.Fill(ds, "Companies");

if (ds.Tables[0].Rows.Count > 0)
{
email.Text = ds.Tables[0].Rows[0]["EmailID"].ToString();
firstname.Text = ds.Tables[0].Rows[0]["FirstName"].ToString();
lastname.Text = ds.Tables[0].Rows[0]["LastName"].ToString();
designation.Text = ds.Tables[0].Rows[0]["Designation"].ToString();
mobile.Text = ds.Tables[0].Rows[0]["ContactNo"].ToString();


Label9.Text = ds.Tables[0].Rows[0]["CompanyName"].ToString();
Label10.Text = ds.Tables[0].Rows[0]["City"].ToString();
Label16.Text = ds.Tables[0].Rows[0]["Address"].ToString();
Label11.Text = ds.Tables[0].Rows[0]["Website"].ToString();
Label12.Text = ds.Tables[0].Rows[0]["CompanyCategory"].ToString();
Label13.Text = ds.Tables[0].Rows[0]["NoOfEmployees"].ToString();
Label15.Text = ds.Tables[0].Rows[0]["Aboutcompany"].ToString();

}
}
}
}
}

Datatype of image is nvarchar(MAX)

I want to fetch image on page load from table in which the path of image is stored and the actual image is in the folder of solution. I have used image control. should i use another control ?

Thanks but the problem has been solved!

how to make changes in this code ?

I can send you aspx and cs file but database file is bit large.

not working

Same error ;\

currentpassword.Text "123" string
ds.Tables[0].Rows[0]["Password"] "123 "object {string}

same error

Please enter correct Current password

and warning on line if(currentpassword.Text ==ds.Tables[0].Rows[0]["password"])

Possible unintended reference comparison; to get a value comparison, cast the right hand side to type 'string'

Same error !!

The name 'Val' does not exist in current context

error in second last line on con.close();

'the name 'con' does not exist in current context'

can you write that code ?

here is update code. everything other than photo gets updated



protected void updatecompany_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=jayraj-pc\\sqlexpress;Initial Catalog=Internship;Integrated Security=True;Pooling=False");


string sql = "UPDATE Companies SET FirstName=@val1, LastName=@val2, UserName=@val3, EmailID=@val4, Password=@val5, ConfirmPassword=@val6, CompanyName=@val7, Designation=@val8, ContactNo=@val9, Country=@val10, State=@val11, City=@val12, CompanyCategory=@val13, NoOfEmployees=@val14, Website=@val15, Aboutcompany=@val16, Address=@val17, CompanyLogo=@val18 where CompanyID=" + Convert.ToInt16(Request.QueryString["CompanyID"].ToString());



try
{

con.Open();

SqlCommand cmd = new SqlCommand(sql, con);

string filepath = Server.MapPath("~/CompanyLogo/" + strFileName);
string path = "~/CompanyLogo/" + strFileName;


cmd.Parameters.AddWithValue("@Val1", firstname.Text);
cmd.Parameters.AddWithValue("@Val2", lastname.Text);
cmd.Parameters.AddWithValue("@Val3", cusername.Text);
cmd.Parameters.AddWithValue("@Val4", email.Text);
cmd.Parameters.AddWithValue("@Val5", password.Text);
cmd.Parameters.AddWithValue("@Val6", cnfpass.Text);
cmd.Parameters.AddWithValue("@Val7", companyname.Text);
cmd.Parameters.AddWithValue("@Val8", designation.Text);
cmd.Parameters.AddWithValue("@Val9", mobileno.Text);
cmd.Parameters.AddWithValue("@Val10", countrylist.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Val11", statelist.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Val12", city.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Val13", companysector.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Val14", DropDownList5.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Val15", website.Text);
cmd.Parameters.AddWithValue("@Val16", aboutcompany.Text);
cmd.Parameters.AddWithValue("@Val17", address.Text);
cmd.Parameters.AddWithValue("@Val18", path);




cmd.CommandType = CommandType.Text;

cmd.ExecuteNonQuery();

}

catch (System.Data.SqlClient.SqlException ex)
{

string msg = "Insert Error:";

msg += ex.Message;

throw new Exception(msg);



}

finally
{

con.Close();

}

}

here it is

protected void updatecompany_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("xyz...");
con.Open();
string filepath = Server.MapPath("~/CompanyLogo/" + strFileName);
string path = "~/CompanyLogo/" + strFileName;
string str = "UPDATE Companies set CompanyLogo='" + path +"' where CompanyID=" + Convert.ToInt16(Request.QueryString["CompanyID"].ToString());
SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();
con.Close();
}

This is insert code


SqlConnection con = new SqlConnection("Data Source=jayraj-pc\\sqlexpress;Initial Catalog=Internship;Integrated Security=True;Pooling=False");

string sql = "INSERT INTO Companies (CompanyLogo) VALUES (@Val1)";



try
{

con.Open();

SqlCommand cmd = new SqlCommand(sql, con);

string filepath = Server.MapPath("~/CompanyLogo/" + strFileName);
string path = "~/CompanyLogo/" + strFileName;



cmd.Parameters.AddWithValue("@Val1", path);




cmd.CommandType = CommandType.Text;

cmd.ExecuteNonQuery();

}

catch (System.Data.SqlClient.SqlException ex)
{

string msg = "Insert Error:";

msg += ex.Message;

throw new Exception(msg);



}

finally
{

con.Close();

}

}
}
}

Thanks, man! I just changed the code to parameterized. now how I can use it to update a photo ?

No. I'm just a beginner

I'm not getting you.. how to make changes i this code to update ?

Check the username and password textboxes of gmail's sign up(add new account) page

not working ;/

not working ;/

Thank you Pranav.

Thank you so much! :)

Exactly same code works perfectly on other form page but not in this one page.

No.

No, I'm not getting any errors. the thing is when I select Country from countrylist dropdown the page doesn't refresh which should as it's auto post back. States are not coming in statelist dropdown.