Click here to Skip to main content
16,004,924 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Gridview With Textbox Pin
Imran Khan Pathan26-Nov-07 23:02
Imran Khan Pathan26-Nov-07 23:02 
GeneralRe: Gridview With Textbox Pin
yardly26-Nov-07 23:16
yardly26-Nov-07 23:16 
GeneralRe: Gridview With Textbox Pin
Imran Khan Pathan26-Nov-07 23:26
Imran Khan Pathan26-Nov-07 23:26 
GeneralRe: Gridview With Textbox Pin
yardly26-Nov-07 23:31
yardly26-Nov-07 23:31 
GeneralRe: Gridview With Textbox Pin
yardly26-Nov-07 23:33
yardly26-Nov-07 23:33 
GeneralRe: Gridview With Textbox Pin
yardly26-Nov-07 23:34
yardly26-Nov-07 23:34 
GeneralRe: Gridview With Textbox Pin
Imran Khan Pathan27-Nov-07 0:06
Imran Khan Pathan27-Nov-07 0:06 
GeneralRe: Gridview With Textbox Pin
yardly27-Nov-07 19:05
yardly27-Nov-07 19:05 
hi good morning..



private void BindGrid()
{
List<ItemEntry> items = new List<ItemEntry>();
for (int i = 0; i < 50; i++)
{
ItemEntry c = new ItemEntry();
items.Add(c);
}
grdPurEntry.DataSource = items;
grdPurEntry.DataBind();
}

public void PON_selectedIndexChanged(object src, EventArgs e)
{
string strPONumber;
strPONumber = ddlpurchaseOrdernumber.SelectedItem.Text.ToString();
//BindData();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ToString());
SqlCommand cmd = new SqlCommand("select MachineName from tbl_PurchaseOrderMaster where Pur_Order_No='" + strPONumber + "'", con);
con.Open();


SqlDataReader dr = cmd.ExecuteReader();
// ddlpurchaseOredernumber.Items.Clear();
while (dr.Read())
{

txtMachineName.Text = dr["MachineName"].ToString();
//txtInvoiceNum.Text = dr["Invoice_No"].ToString();

}

con.Close();


// Load Grid

//string strPONumber;
//strPONumber = ddlpurchaseOrdernumber.SelectedItem.Text.ToString();
string strPartNumber = "";

string strPartDescription = "";
string strOrderedQuantity = "";
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlDataAdapter ad = new SqlDataAdapter("SELECT Part_Number,Part_Description,Ordered_Quantity FROM tbl_PurchaseOrderDetails where Pur_Order_No ='" + strPONumber + "'", con);// where MachineName='" + txtMachineName.Text + "'", con);

DataSet ds = new DataSet();

ad.Fill(ds, "PurOrderNum");
DataTable dt = ds.Tables[0];
foreach (DataRow dr1 in dt.Rows)
{
strPartNumber = dr1["Part_Number"].ToString();
strPartDescription = dr1["Part_Description"].ToString();
strOrderedQuantity = dr1["Ordered_Quantity"].ToString();

}

//string strPONumber;
//strPONumber = ddlpurchaseOrdernumber.SelectedItem.Text.ToString();
foreach (GridViewRow row in grdPurEntry.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
if (String.IsNullOrEmpty(((TextBox)row.FindControl("txtPartNumber")).Text))
{
((TextBox)row.FindControl("txtPartNumber")).Text = strPartNumber.ToString();

if (strPartDescription != "")
{
((TextBox)row.FindControl("txtPartDescription")).Text = strPartDescription.ToString();
}


if (strOrderedQuantity != "")
{
((TextBox)row.FindControl("txtOrderedQuantity")).Text = strOrderedQuantity.ToString();
}
// else
//{
// ((TextBox)row.FindControl("txtOrderedQuantity")).Text;// = "0";

//}
ddlpurchaseOrdernumber.SelectedIndex = 0;
return;
}
}
}
// ddlpurchaseOrdernumber.SelectedIndex = 0;

}

while clicking the dropdown box i have to bind the values to the gridview .. but it s not working ...


protected void btnSave_Click(object src, EventArgs e)
{
try{
Cls_PurchaseEntry purent = new Cls_PurchaseEntry();
purent.Pur_Order_No = Convert.ToInt32(ddlpurchaseOrdernumber.SelectedItem.Value.ToString());
purent.Invoice_No = Convert.ToInt32(txtInvoiceNum.Text);
purent.MachineName = txtMachineName.Text;


foreach (GridViewRow row in grdPurEntry.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
string Part_Number = ((TextBox)row.FindControl("txtPartNumber")).Text;

purent.Part_Number = Part_Number;

string Part_Description = ((TextBox)row.FindControl("txtPartDescription")).Text;

purent.Part_Description = Part_Description;

string Ordered_Quantity = ((TextBox)row.FindControl("txtOrderedQuantity")).Text;

purent.Ordered_Quantity =Convert.ToInt32(Ordered_Quantity);

string Received_Quantity = ((TextBox)row.FindControl("txtReceivedQuantity")).Text;
if (Received_Quantity != "")
{
purent.Received_Quantity = Convert.ToInt32(Received_Quantity);
}

// purent.Part_Number = Part_Number;
//purent.Part_Description = Part_Description;
//purent.Ordered_Quantity = Convert.ToInt32(Ordered_Quantity);
// purent.Received_Quantity = Convert.ToInt32(Received_Quantity);
purent.User_Created = Session["Name"].ToString();
purent.User_Modified = Session["Name"].ToString();
purent.Date_Created = Convert.ToDateTime(txtDate.Text);
purent.Date_Modified = Convert.ToDateTime(txtDate.Text);
IMMS_SaveUtility immsUtil = new IMMS_SaveUtility();
string n = immsUtil.savePurchaseEntry(purent);
}
}
lbldispm.Text = "PurchaseEntry added successfully!";

}

catch (Exception ex)
{
lbldispm.Text = "Error completing the operation!";
}
}




Questiongetting the value from IFrame Pin
chandler8326-Nov-07 22:22
chandler8326-Nov-07 22:22 
AnswerRe: getting the value from IFrame Pin
Venkatesh Mookkan26-Nov-07 23:25
Venkatesh Mookkan26-Nov-07 23:25 
Questionpopulate two dropdownlist and a textbox Pin
raghu.chanti26-Nov-07 21:58
raghu.chanti26-Nov-07 21:58 
AnswerRe: populate two dropdownlist and a textbox Pin
Imran Khan Pathan26-Nov-07 22:15
Imran Khan Pathan26-Nov-07 22:15 
QuestionCreating Interactive Graphs Pin
varshavmane26-Nov-07 21:52
varshavmane26-Nov-07 21:52 
AnswerRe: Creating Interactive Graphs Pin
Sun Rays26-Nov-07 21:53
Sun Rays26-Nov-07 21:53 
GeneralRe: Creating Interactive Graphs Pin
varshavmane26-Nov-07 21:58
varshavmane26-Nov-07 21:58 
GeneralRe: Creating Interactive Graphs Pin
N a v a n e e t h26-Nov-07 22:00
N a v a n e e t h26-Nov-07 22:00 
GeneralRe: Creating Interactive Graphs Pin
_AK_26-Nov-07 22:00
_AK_26-Nov-07 22:00 
GeneralRe: Creating Interactive Graphs Pin
N a v a n e e t h26-Nov-07 22:06
N a v a n e e t h26-Nov-07 22:06 
GeneralRe: Creating Interactive Graphs Pin
_AK_26-Nov-07 22:08
_AK_26-Nov-07 22:08 
GeneralRe: Creating Interactive Graphs Pin
_AK_26-Nov-07 22:00
_AK_26-Nov-07 22:00 
GeneralRe: Creating Interactive Graphs Pin
varshavmane26-Nov-07 22:03
varshavmane26-Nov-07 22:03 
GeneralRe: Creating Interactive Graphs Pin
_AK_26-Nov-07 22:08
_AK_26-Nov-07 22:08 
GeneralRe: Creating Interactive Graphs Pin
varshavmane26-Nov-07 22:10
varshavmane26-Nov-07 22:10 
GeneralRe: Creating Interactive Graphs Pin
_AK_26-Nov-07 22:27
_AK_26-Nov-07 22:27 
GeneralRe: Creating Interactive Graphs Pin
varshavmane26-Nov-07 22:32
varshavmane26-Nov-07 22:32 

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.