Click here to Skip to main content
13,732,108 members

Comments by Software Engineer 892 (Top 102 by date)

Software Engineer 892 25-Mar-15 7:02am View
   
Many Thanks..its working now.
Software Engineer 892 20-Nov-14 3:02am View
   
Thank you...
Software Engineer 892 20-Nov-14 3:01am View
   
Thanks
Software Engineer 892 19-Nov-14 2:14am View
   
where should i place ur code. becoz we need one function/method name in OnClientClick="return chkAllValues()" like this.

Please help.
Software Engineer 892 19-Nov-14 1:42am View
   
Sir,

This is my code for other textboxes validation for same page.

Can you please checkboxes script also in this code. am confused.

<script type="text/javascript">
function chkAllValues()
{

if(document.getElementById('TxtFirstName').value=="" || document.getElementById('TxtFirstName').value==0)
{
alert("Please enter First Name");
document.getElementById('TxtFirstName').focus();
return false;
}

if(document.getElementById('TxtLastName').value=="" || document.getElementById('TxtLastName').value==0)
{
alert("Please enter Last Name");
document.getElementById('TxtLastName').focus();
return false;
}

if(document.getElementById('TxtDepartment').value=="" || document.getElementById('TxtDepartment').value==0)
{
alert("Please enter Department");
document.getElementById('TxtDepartment').focus();
return false;
}


return confirm('are you sure ? you want to Submit this details ?');
}



BUTTON
======
<asp:ImageButton ID="BtnSubmit" runat="server"
ImageUrl="Submit.png" CausesValidation="true"
onclick="BtnSubmit_Click" OnClientClick="return chkAllValues()"/>
</script>

Thanks in advance.
Software Engineer 892 7-Sep-14 6:55am View
   
Please can you show me.
Thanks.
Software Engineer 892 2-Jun-14 3:02am View
   
Thanks...... its working.
Software Engineer 892 22-May-14 6:07am View
   
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
Software Engineer 892 16-Mar-14 7:20am View
   
But how to concat and read from database am using this ?
lblFirstName.Text = reader["FirstName"].ToString();
lblLastName.Text = reader["LastName"].ToString();
Software Engineer 892 16-Mar-14 7:20am View
   
But how to concat and read from database am using this ?
lblFirstName.Text = reader["FirstName"].ToString();
lblLastName.Text = reader["LastName"].ToString();
Software Engineer 892 9-Mar-14 7:26am View
   
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.
Software Engineer 892 2-Feb-14 5:59am View
   
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.
Software Engineer 892 18-Sep-13 4:31am View
   
Thanks, its works fine for me.
Software Engineer 892 26-Aug-13 3:31am View
   
Sir, am confused am unable to understand. I need a popup message for every already existing column/ field.

Please help me. Thanks.
Software Engineer 892 26-Aug-13 1:58am View
   
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.
Software Engineer 892 25-Aug-13 4:55am View
   
only i can validate username here, please can you help for other fields.
Software Engineer 892 1-Jul-13 4:22am View
   
am using Calendar Extender.
Software Engineer 892 30-Jun-13 5:57am View
   
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.
Software Engineer 892 16-Jun-13 3:00am View
   
help me, am unable to understand.

Pass Gridview row to another page gridview when hyperlink click for particular row in asp.net c#.
Software Engineer 892 26-May-13 6:57am View
   
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.
Software Engineer 892 22-May-13 19:56pm View
   
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.
Software Engineer 892 22-May-13 19:42pm View
   
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........
Software Engineer 892 22-May-13 19:30pm View
   
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...
Software Engineer 892 23-Apr-13 4:09am View
   
please can you show me how to do that, thanks.
Software Engineer 892 22-Apr-13 3:29am View
   
Deleted
boss, actually my tables are in sqlserver database. But the live data is in oracle database.

presently i cannot display the data in my proj from Sqlserver database.

so how can i do that, and display in my proj.

please help.
Software Engineer 892 20-Apr-13 6:04am View
   
I have improved the question,
please help
thanks
Software Engineer 892 16-Apr-13 2:45am View
   
I need one empty record fixed in table.
please help

Thanks
Software Engineer 892 16-Apr-13 2:45am View
   
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
Software Engineer 892 15-Apr-13 4:19am View
   
Thanks boss, i got it, the error was in line 6...which u have posted.
Now its working fine.

Thank u very much Raje...
Software Engineer 892 15-Apr-13 4:12am View
   
please help me frnds. thanks in advance.
Software Engineer 892 15-Apr-13 4:03am View
   
please can you show me how to do that, am trying a lot. please help thanks
Software Engineer 892 15-Apr-13 3:57am View
   
am inserting this data using gridview footer add button
Software Engineer 892 10-Apr-13 3:47am View
   
I have pasted ur code....but it shows an error

The name 'ViewState' does not exist in the current context
Software Engineer 892 10-Apr-13 3:09am View
   
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.
Software Engineer 892 10-Apr-13 3:04am View
   
Hello boss if i remove that 3 textboxes code...am unable to see the entered values in database from that textboxes..
Software Engineer 892 10-Apr-13 3:00am View
   
remove first 3 textboxes
Software Engineer 892 10-Apr-13 2:51am View
   
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;
}
}
Software Engineer 892 10-Apr-13 2:43am View
   
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;
}
}
Software Engineer 892 10-Apr-13 2:43am View
   
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;
}
}
Software Engineer 892 10-Apr-13 2:43am View
   
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;
}
}
Software Engineer 892 10-Apr-13 2:39am View
   
Deleted
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;
}
}
Software Engineer 892 10-Apr-13 2:39am View
   
Deleted
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;
}
}
Software Engineer 892 10-Apr-13 2:39am View
   
Deleted
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;
}
}
Software Engineer 892 10-Apr-13 2:39am View
   
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;
}
}
Software Engineer 892 8-Apr-13 3:50am View
   
thanks..!!
Software Engineer 892 22-Mar-13 9:22am View
   
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...
Software Engineer 892 22-Mar-13 9:11am View
   
already i have 10gb free space
Software Engineer 892 26-Feb-13 3:02am View
   
Thank you So Much my dear Friend, Its working.
Software Engineer 892 25-Feb-13 5:03am View
   
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.
Software Engineer 892 25-Feb-13 3:21am View
   
Please can you post your code.
Software Engineer 892 10-Feb-13 7:01am View
   
Many Thanks PALLAVI Garu.
Software Engineer 892 2-Feb-13 4:44am View
   
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 ?
Software Engineer 892 30-Jan-13 0:46am View
   
Thank you sir for ur help, its working.
Software Engineer 892 30-Jan-13 0:45am View
   
Thank you sir for ur help, its working.
Software Engineer 892 14-Jan-13 4:09am View
   
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.
Software Engineer 892 14-Jan-13 2:52am View
   
Sir, If i host one after the other its only opens one...because we can assign only one as default...Please help.
Software Engineer 892 13-Jan-13 5:37am View
   
and also checks the heights in style 13 and style 14.
Software Engineer 892 13-Jan-13 5:36am View
   
please remove table id = table14
Software Engineer 892 10-Jan-13 11:17am View
   
No Sir, Please help me how to add this.
Software Engineer 892 2-Jan-13 3:30am View
   
Thanks...I got it.
Software Engineer 892 1-Jan-13 3:12am View
   
How to add Reference to the assembly...Please help THANKS
Software Engineer 892 31-Dec-12 3:34am View
   
anybody there , please solve.
Software Engineer 892 31-Dec-12 2:57am View
   
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
Software Engineer 892 18-Dec-12 6:16am View
   
Thanks a lot.....
Software Engineer 892 15-Dec-12 5:11am View
   
Thank you Mr.nagalkumar.........its working fine.
Software Engineer 892 1-Dec-12 3:37am View
   
Boss, I need Survey Examples....Please help.
THANKS........
Software Engineer 892 27-Nov-12 1:11am View
   
This is done by coding, I used Sql Datasource.

Please help, How to display Confirmation Message using SqlDATASOURCE.
Software Engineer 892 19-Nov-12 2:24am View
   
Thanx, 103 is working
Software Engineer 892 14-Nov-12 4:10am View
   
ya
Software Engineer 892 14-Nov-12 3:43am View
   
according to user name..... company logo must be displayed after login...please help.
THANKS.
Software Engineer 892 14-Nov-12 3:41am View
   
ya, i want to take the picture from database, so how can i do this ? ?

Please help.
Software Engineer 892 10-Nov-12 7:44am View
   
Already i used Update panel.....still it refreshing complete page....when paging clicks.
Please help.
Software Engineer 892 16-Oct-12 7:30am View
   
Thank you very Much @ vivek tiwari.
Software Engineer 892 16-Oct-12 6:59am View
   
@ 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.
Software Engineer 892 15-Oct-12 4:20am View
   
also i used namespace using System.globalization;
Software Engineer 892 15-Oct-12 4:19am View
   
@gopal pradhan SIR, its not working.
it throws an error
'System.Globalization.CultureInfo' is a 'type', which is not valid in the given context
Software Engineer 892 1-Oct-12 7:27am View
   
Thanks Raghu Gowda
Software Engineer 892 28-Aug-12 4:40am View
   
Just Selecting Month from Dropdownlist must show all the records related to january
Please help
Software Engineer 892 28-Aug-12 4:39am View
   
Please can you show me how to do this, am unable to understand
Software Engineer 892 8-Aug-12 8:14am View
   
in gridview my column is cell[8]
Software Engineer 892 8-Aug-12 8:12am View
   
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
Software Engineer 892 8-Aug-12 8:09am View
   
please tell me
Software Engineer 892 8-Aug-12 7:40am View
   
not working ur code
Software Engineer 892 8-Aug-12 7:26am View
   
change the back color of cell, if it is less than system date
Software Engineer 892 8-Aug-12 7:25am View
   
If the Date is less than system date, It must change the cackcolor of that particular cell.
Software Engineer 892 8-Aug-12 7:24am View
   
where should we write this code, I mean in which event
Software Engineer 892 29-Jul-12 5:02am View
   
How you have solved, 9 + 5 = 126 Please Explain... I need it.

Thanks.
Software Engineer 892 25-Jul-12 5:07am View
   
Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
Software Engineer 892 23-Jul-12 6:39am View
   
am using .Net 3.5..............Please help.
Software Engineer 892 17-Jul-12 5:45am View
   
Query using sqlserver 2005
Software Engineer 892 17-Jul-12 5:44am View
   
So, how to write a query to display the records alphabet wise(a-z)....Please help
Software Engineer 892 17-Jul-12 5:00am View
   
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.
Software Engineer 892 16-Jul-12 6:43am View
   
Many Thanks Nilesh patil its working now.
Software Engineer 892 16-Jul-12 5:13am View
   
if the year is less than current year , it must display a message invalid year

Pleaseeeeeeeeeeeeee help.
Software Engineer 892 16-Jul-12 4:18am View
   
May be , due to this it is not showing the year problem.
Software Engineer 892 16-Jul-12 4:18am View
   
Boss, actually this is my registration form, i this am using check user availability also.

Please help.
Software Engineer 892 16-Jul-12 4:14am View
   
yes, i need javascript
Software Engineer 892 16-Jul-12 4:13am View
   
yes
Software Engineer 892 16-Jul-12 4:05am View
   
what to write on page load...Please help
Software Engineer 892 16-Jul-12 3:47am View
   
ya, but it doesn't work........ please help me.
Software Engineer 892 15-Jul-12 3:45am View
   
Please tell me, am not familiar with CSS. Please can u ?
Software Engineer 892 15-Jul-12 3:00am View
   
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.

Advertise | Privacy | Cookies | Terms of Service
Web06-2016 | 2.8.180920.1 | Last Updated 1 Jan 1900
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid