Comments by Software Engineer 892 (Top 102 by date)

Please can you show me.
Thanks.

Thanks...... its working.

sir, if i set read only to true....it is not inserting in database table

this is my code in page load

TxtJoiningDate.ReadOnly = true;

Please help.
Thanks

But how to concat and read from database am using this ?
lblFirstName.Text = reader["FirstName"].ToString();
lblLastName.Text = reader["LastName"].ToString();

But how to concat and read from database am using this ?
lblFirstName.Text = reader["FirstName"].ToString();
lblLastName.Text = reader["LastName"].ToString();

Sir, I need like this...

if UserType is admin -----> redirect to admin pages
if UserType is User ---> redirect to UserPages

If UserName and Password is wrong then display message as ...Invalid UserName or Password.

Please help its urgent.

I have Tried this,

Select * from dbo.stud_Details where JoinDateTime <= DATE_SUB(JoinDateTime (),INTERVAL 1 DAY);

Please can you help me.
I want to display the records less than todays date to Till todays date.

Thanks, its works fine for me.

Sir, am confused am unable to understand. I need a popup message for every already existing column/ field.

Please help me. Thanks.

hello sir,
according to ur its working fine. but how should i know which record already exists in database. i mean which field is already exists.

when i click on add button, it should get a popup message. which field already exists.

Please Please can you help me.

Thanks.

only i can validate username here, please can you help for other fields.

am using Calendar Extender.

my dear friend,

for Adding a new record. you should use add button and also Use INSERT Query.

So, New record will be Inserted. using INSERT QUERY.

Code must be written in Gridview RowCommand event.

I think you have understood.

help me, am unable to understand.

Pass Gridview row to another page gridview when hyperlink click for particular row in asp.net c#.

hello boss, its working for me, but the problem is ........i already have back color on first column.

again when i mouse over, the color should effect the complete row including first column also.

Please help.

Yes boss, if the ExpiryDate columns date is less than todays date, only that particular cell must become red.

Note : I want to make the cell back color red, if the cell is less than todays date.

Please help.

Sorry, this becomes all the column red.....i need if the date is less than todays date.
My column name is ExpiryDate.

Please help thanks........

This is my code, the complete row is becoming red,,, i need only 4th cell.

protected void GvManageUsers_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow)
{
if (Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "ExpiryDate")) < DateTime.Now)
{
e.Row.BackColor = System.Drawing.Color.Red;
e.Row.ForeColor = System.Drawing.Color.White;
}
else
{
e.Row.BackColor = System.Drawing.Color.White;
e.Row.ForeColor = System.Drawing.Color.Black;

}

}


Please help thanks...

please can you show me how to do that, thanks.

I have improved the question,
please help
thanks

I need one empty record fixed in table.
please help

Thanks

because i can see gridview footer textboxes, if we have atleast one record in gridview.

Otherwise i cannot see footer textboxes in gridview.

Please help

Thanks boss, i got it, the error was in line 6...which u have posted.
Now its working fine.

Thank u very much Raje...

please help me frnds. thanks in advance.

please can you show me how to do that, am trying a lot. please help thanks

am inserting this data using gridview footer add button

I have pasted ur code....but it shows an error

The name 'ViewState' does not exist in the current context

My requirement is :

Total i have 10 textboxes and a submit button. this data will be save in database...its fine till here.

Now my requirement is ?

for first record i will enter all the textboxes and clicks on submit button..its saves in DB.

for second record only i will enter other 7 textboxes...because the first 3 boxes will be common to all records.

so that, if i enter in 7 textboxes....in database i should see complete 10 textboxes data in one record.

please help.

Hello boss if i remove that 3 textboxes code...am unable to see the entered values in database from that textboxes..

remove first 3 textboxes

i have send another code ..please help this is my code....THIS IS SUBMIT PART


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

public partial class _Default : System.Web.UI.Page
{
private static readonly string _connString = String.Empty;
SqlConnection con = new SqlConnection(_connString);


protected void Page_Load(object sender, EventArgs e)
{

}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(_connString);
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from Equipment_Inventory", con);
SqlCommandBuilder builder = new SqlCommandBuilder(da);
DataSet ds = new DataSet("Equipment_Inventory");
da.Fill(ds, "Equipment_Inventory");

DataTable Equipment_InventoryTable = ds.Tables["Equipment_Inventory"];
DataRow row = Equipment_InventoryTable.NewRow();

row["Dept_code"] = TxtDeptCode.Text;
row["Dept_desc"] = TxtDescription.Text;
row["Dept_telno"] = TxtTelephoneNo.Text;
row["Dept_dirmgr"] = TxtDirector_Manager.Text;
row["Equipment_type"] = DDL_EquipmentType.SelectedItem.Text;
row["Maker"] = DDL_Maker.SelectedItem.Text;
row["Model"] = TxtModel.Text;
row["Serialno"] = TxtSerialNo.Text;
row["TagNo"] = TxtKKIA_GACA_tag.Text;
row["Assignedto"] = TxtAssignedTo.Text;
row["Location"] = TxtLocation.Text;
row["Dentry"] = DateTime.Now.ToString();

Equipment_InventoryTable.Rows.Add(row);
da.Update(ds, "Equipment_Inventory");
con.Close();

TxtDeptCode.Text = "";
TxtDescription.Text = "";
TxtTelephoneNo.Text = "";
TxtDirector_Manager.Text = "";
DDL_EquipmentType.SelectedItem.Text = "";
DDL_Maker.SelectedItem.Text = "";
TxtModel.Text = "";
TxtSerialNo.Text = "";
TxtKKIA_GACA_tag.Text = "";
TxtAssignedTo.Text = "";
TxtLocation.Text = "";



ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Inventory added Successfully');", true);
}


protected void BtnCancel_Click(object sender, EventArgs e)
{
TxtDeptCode.Text = "";
TxtDescription.Text = "";
TxtTelephoneNo.Text = "";
TxtDirector_Manager.Text = "";
DDL_EquipmentType.SelectedItem.Text = "";
DDL_Maker.SelectedItem.Text = "";

TxtModel.Text = "";
TxtSerialNo.Text = "";
TxtKKIA_GACA_tag.Text = "";
TxtAssignedTo.Text = "";
TxtLocation.Text = "";
}


static _Default()
{
_connString = WebConfigurationManager.ConnectionStrings["Inventory_DBConnectionString"].ConnectionString;
}
}

SORRY THIS IS MY CODE

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

public partial class _Default : System.Web.UI.Page
{
private static readonly string _connString = String.Empty;
SqlConnection con = new SqlConnection(_connString);


protected void Page_Load(object sender, EventArgs e)
{

}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(_connString);
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from Equipment_Inventory", con);
SqlCommandBuilder builder = new SqlCommandBuilder(da);
DataSet ds = new DataSet("Equipment_Inventory");
da.Fill(ds, "Equipment_Inventory");

DataTable Equipment_InventoryTable = ds.Tables["Equipment_Inventory"];
DataRow row = Equipment_InventoryTable.NewRow();

row["Dept_code"] = TxtDeptCode.Text;
row["Dept_desc"] = TxtDescription.Text;
row["Dept_telno"] = TxtTelephoneNo.Text;
row["Dept_dirmgr"] = TxtDirector_Manager.Text;
row["Equipment_type"] = DDL_EquipmentType.SelectedItem.Text;
row["Maker"] = DDL_Maker.SelectedItem.Text;
row["Model"] = TxtModel.Text;
row["Serialno"] = TxtSerialNo.Text;
row["TagNo"] = TxtKKIA_GACA_tag.Text;
row["Assignedto"] = TxtAssignedTo.Text;
row["Location"] = TxtLocation.Text;
row["Dentry"] = DateTime.Now.ToString();

Equipment_InventoryTable.Rows.Add(row);
da.Update(ds, "Equipment_Inventory");
con.Close();

TxtDeptCode.Text = "";
TxtDescription.Text = "";
TxtTelephoneNo.Text = "";
TxtDirector_Manager.Text = "";
DDL_EquipmentType.SelectedItem.Text = "";
DDL_Maker.SelectedItem.Text = "";
TxtModel.Text = "";
TxtSerialNo.Text = "";
TxtKKIA_GACA_tag.Text = "";
TxtAssignedTo.Text = "";
TxtLocation.Text = "";



ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Inventory added Successfully');", true);
}
protected void BtnCancel_Click(object sender, EventArgs e)
{
TxtDeptCode.Text = "";
TxtDescription.Text = "";
TxtTelephoneNo.Text = "";
TxtDirector_Manager.Text = "";
DDL_EquipmentType.SelectedItem.Text = "";
DDL_Maker.SelectedItem.Text = "";

TxtModel.Text = "";
TxtSerialNo.Text = "";
TxtKKIA_GACA_tag.Text = "";
TxtAssignedTo.Text = "";
TxtLocation.Text = "";
}


static _Default()
{
_connString = WebConfigurationManager.ConnectionStrings["Inventory_DBConnectionString"].ConnectionString;
}
}

SORRY THIS IS MY CODE

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

public partial class _Default : System.Web.UI.Page
{
private static readonly string _connString = String.Empty;
SqlConnection con = new SqlConnection(_connString);


protected void Page_Load(object sender, EventArgs e)
{

}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(_connString);
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from Equipment_Inventory", con);
SqlCommandBuilder builder = new SqlCommandBuilder(da);
DataSet ds = new DataSet("Equipment_Inventory");
da.Fill(ds, "Equipment_Inventory");

DataTable Equipment_InventoryTable = ds.Tables["Equipment_Inventory"];
DataRow row = Equipment_InventoryTable.NewRow();

row["Dept_code"] = TxtDeptCode.Text;
row["Dept_desc"] = TxtDescription.Text;
row["Dept_telno"] = TxtTelephoneNo.Text;
row["Dept_dirmgr"] = TxtDirector_Manager.Text;
row["Equipment_type"] = DDL_EquipmentType.SelectedItem.Text;
row["Maker"] = DDL_Maker.SelectedItem.Text;
row["Model"] = TxtModel.Text;
row["Serialno"] = TxtSerialNo.Text;
row["TagNo"] = TxtKKIA_GACA_tag.Text;
row["Assignedto"] = TxtAssignedTo.Text;
row["Location"] = TxtLocation.Text;
row["Dentry"] = DateTime.Now.ToString();

Equipment_InventoryTable.Rows.Add(row);
da.Update(ds, "Equipment_Inventory");
con.Close();

TxtDeptCode.Text = "";
TxtDescription.Text = "";
TxtTelephoneNo.Text = "";
TxtDirector_Manager.Text = "";
DDL_EquipmentType.SelectedItem.Text = "";
DDL_Maker.SelectedItem.Text = "";
TxtModel.Text = "";
TxtSerialNo.Text = "";
TxtKKIA_GACA_tag.Text = "";
TxtAssignedTo.Text = "";
TxtLocation.Text = "";



ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Inventory added Successfully');", true);
}
protected void BtnCancel_Click(object sender, EventArgs e)
{
TxtDeptCode.Text = "";
TxtDescription.Text = "";
TxtTelephoneNo.Text = "";
TxtDirector_Manager.Text = "";
DDL_EquipmentType.SelectedItem.Text = "";
DDL_Maker.SelectedItem.Text = "";

TxtModel.Text = "";
TxtSerialNo.Text = "";
TxtKKIA_GACA_tag.Text = "";
TxtAssignedTo.Text = "";
TxtLocation.Text = "";
}


static _Default()
{
_connString = WebConfigurationManager.ConnectionStrings["Inventory_DBConnectionString"].ConnectionString;
}
}

SORRY THIS IS MY CODE

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

public partial class _Default : System.Web.UI.Page
{
private static readonly string _connString = String.Empty;
SqlConnection con = new SqlConnection(_connString);


protected void Page_Load(object sender, EventArgs e)
{

}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(_connString);
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from Equipment_Inventory", con);
SqlCommandBuilder builder = new SqlCommandBuilder(da);
DataSet ds = new DataSet("Equipment_Inventory");
da.Fill(ds, "Equipment_Inventory");

DataTable Equipment_InventoryTable = ds.Tables["Equipment_Inventory"];
DataRow row = Equipment_InventoryTable.NewRow();

row["Dept_code"] = TxtDeptCode.Text;
row["Dept_desc"] = TxtDescription.Text;
row["Dept_telno"] = TxtTelephoneNo.Text;
row["Dept_dirmgr"] = TxtDirector_Manager.Text;
row["Equipment_type"] = DDL_EquipmentType.SelectedItem.Text;
row["Maker"] = DDL_Maker.SelectedItem.Text;
row["Model"] = TxtModel.Text;
row["Serialno"] = TxtSerialNo.Text;
row["TagNo"] = TxtKKIA_GACA_tag.Text;
row["Assignedto"] = TxtAssignedTo.Text;
row["Location"] = TxtLocation.Text;
row["Dentry"] = DateTime.Now.ToString();

Equipment_InventoryTable.Rows.Add(row);
da.Update(ds, "Equipment_Inventory");
con.Close();

TxtDeptCode.Text = "";
TxtDescription.Text = "";
TxtTelephoneNo.Text = "";
TxtDirector_Manager.Text = "";
DDL_EquipmentType.SelectedItem.Text = "";
DDL_Maker.SelectedItem.Text = "";
TxtModel.Text = "";
TxtSerialNo.Text = "";
TxtKKIA_GACA_tag.Text = "";
TxtAssignedTo.Text = "";
TxtLocation.Text = "";



ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Inventory added Successfully');", true);
}
protected void BtnCancel_Click(object sender, EventArgs e)
{
TxtDeptCode.Text = "";
TxtDescription.Text = "";
TxtTelephoneNo.Text = "";
TxtDirector_Manager.Text = "";
DDL_EquipmentType.SelectedItem.Text = "";
DDL_Maker.SelectedItem.Text = "";

TxtModel.Text = "";
TxtSerialNo.Text = "";
TxtKKIA_GACA_tag.Text = "";
TxtAssignedTo.Text = "";
TxtLocation.Text = "";
}


static _Default()
{
_connString = WebConfigurationManager.ConnectionStrings["Inventory_DBConnectionString"].ConnectionString;
}
}

This is my code, Please help

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

public partial class ViewInventory : System.Web.UI.Page
{
private static readonly string _connString = String.Empty;
SqlConnection con = new SqlConnection(_connString);

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadInventoryData();
}
}


private void LoadInventoryData()
{
SqlConnection con = new SqlConnection(_connString);


//SqlCommand cmd = new SqlCommand("Select * from Equipment_Inventory", con);
SqlCommand cmd = new SqlCommand("Select Dept_code as DeptCode, Dept_desc as Description, Dept_telno as TelephoneNo, Dept_dirmgr as DirectorManager, Equipment_type as EquipmentType, Maker as Maker, Model as Model, Serialno as SerialNo, TagNo as TagNo, Assignedto as AssignedTo, Location as Location from Equipment_Inventory", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GVInventoryRecords.DataSource = ds;
GVInventoryRecords.DataBind();


}


static ViewInventory()
{
_connString = WebConfigurationManager.ConnectionStrings["Inventory_DBConnectionString"].ConnectionString;
}
}

thanks..!!

actually this database is of 6,226 kb only.......then what will be the problem. i have still 10gb free space in C drive.

Please help me.

Thanks...

already i have 10gb free space

Thank you So Much my dear Friend, Its working.

its showing Paranthesis expected error in this line

Response.Write("<script language="JavaScript">alert('UserName Already Exists, Try another')</script>");



This is my code................

protected void TxtUserName_TextChanged(object sender, EventArgs e)
{

String str = "Select Username from UserInfo where UserName='" + TxtUserName.Text + "'";
SqlConnection con = new SqlConnection(_connString);
SqlCommand cmd = new SqlCommand(str, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())


{


Response.Write("<script language="JavaScript">alert('UserName Already Exists, Try another')</script>");
}
else
{
Response.Write("<script language="JavaScript">alert('UserName Available, Please proceed')</script>");
}
con.Close();

}

Please help thanks.

Please can you post your code.

Many Thanks PALLAVI Garu.

Sir, it is inserting perfectly in records Table....if records table reachs 200 records.
the last 50 records must be automatically inserted into new table(ArchievedTable)

So, in record table it will have 150 records and in Archieved Table it will have 50 Records.

Please can u show me how to do this ?

Thank you sir for ur help, its working.

Thank you sir for ur help, its working.

I have Two web applications...ok

for the first application the start page is Home.aspx
and for second application the start page is login.aspx

and I have Windows 2003 IIS 7 Webserver.

In this i have created a virtual directory gave permissions and finally i gave default page as Home.aspx

and how to create another virtual directory and host 2nd application.

and Finally how to run the both applications.

Please help. THANKS.

Sir, If i host one after the other its only opens one...because we can assign only one as default...Please help.

and also checks the heights in style 13 and style 14.

please remove table id = table14

No Sir, Please help me how to add this.

Thanks...I got it.

How to add Reference to the assembly...Please help THANKS

anybody there , please solve.

no, its not working. if i put page load code in prerender Gridview is not displaying.
and if i put the pageload code both in prerender and pageload...then also its not working..Please help am fresher

Thanks a lot.....

Thank you Mr.nagalkumar.........its working fine.

Boss, I need Survey Examples....Please help.
THANKS........

This is done by coding, I used Sql Datasource.

Please help, How to display Confirmation Message using SqlDATASOURCE.

Thanx, 103 is working

ya

according to user name..... company logo must be displayed after login...please help.
THANKS.

ya, i want to take the picture from database, so how can i do this ? ?

Please help.

Already i used Update panel.....still it refreshing complete page....when paging clicks.
Please help.

Thank you very Much @ vivek tiwari.

@ vivektiwari97701 your solution is good it is correct what i want, but it is not displaying am or pm

it is displaying as 16/10/2012 04:07

I need it as 16/10/2012 04:07:42 pm

Please help.

Thanks for EVERRRRRR.

also i used namespace using System.globalization;

@gopal pradhan SIR, its not working.
it throws an error
'System.Globalization.CultureInfo' is a 'type', which is not valid in the given context

Thanks Raghu Gowda

Just Selecting Month from Dropdownlist must show all the records related to january
Please help

Please can you show me how to do this, am unable to understand

in gridview my column is cell[8]

i will tell you clear..am working on ASp.net C#

I have a column name with ExpiryDate in GRIDVIEW, if the date is less than system date, that particular cell must be red color background

my date is 16\06\2012

Please help

please tell me

not working ur code

change the back color of cell, if it is less than system date

If the Date is less than system date, It must change the cackcolor of that particular cell.

where should we write this code, I mean in which event

How you have solved, 9 + 5 = 126 Please Explain... I need it.

Thanks.

Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

am using .Net 3.5..............Please help.

Query using sqlserver 2005

So, how to write a query to display the records alphabet wise(a-z)....Please help

Boss, it is not displaying alphabet wise in 2nd and other pages, only its displaying on first page of gridview when selected from dropdown. and i have take out Gridview1.databind from page indexing.....even its not working...PLEASE HELP.

Many Thanks Nilesh patil its working now.

if the year is less than current year , it must display a message invalid year

Pleaseeeeeeeeeeeeee help.

May be , due to this it is not showing the year problem.

Boss, actually this is my registration form, i this am using check user availability also.

Please help.

yes, i need javascript

yes

what to write on page load...Please help

ya, but it doesn't work........ please help me.

Please tell me, am not familiar with CSS. Please can u ?

Boss, I need some help from you.

what you have gave me , its working fine. BUT

I need to show this loading image in centre of GRIDVIEW. Please help.