|
You can create a handler for the RowDataBound event of the GridView control, and in the handler you can get reference to the DetailsView control, then you can pass the CustomerID value from the master record to the input controls placed inside the DetailsView control.
|
|
|
|
|
Thankyou for the reply, it would seem from the number of posts on various ASP.NET forums I am not alone. I am not alone, I will explore the RowDataBound event as a means to capture the values in the GridView (CustomerID & Name)
I thought this was going to be easy, hooking up a Gridview and DetailsView for some standard Master/Detail data entry.
For anyone reading this post if you can recommend a good book that focuses on C# ASP.NET database front ends I would appreciate knowing its name. I have already purchased 3 books reviewed on the Microsoft site, one is over 1000 pages only find very little on hooking up these two controls in a real world examples.
I have both forms linked and working well when details data exists. I also have the DetailsView defaulting to Insert by using the following useful code snippet I found on another post, when there is no detail record.
protected void SqlDataSource2_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
if (e.AffectedRows < 1)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
}
}
Its at this point I want to populate the CustomerId & Name values from the selected Master record into the empty DetailsView record which is on a different page.
Many smaller examples show both controls on the same page.
I have tried the following from a post by Polita Paulas the creator of the GridView, DetailsView and FormView controls.
"The best way to do this is to handle the DataBound event, check if the Mode is Insert, then set the text in the controls to the default properties.
For instance:
protected void DetailsView1_DataBound(object sender, EventArgs e)
{
if (DetailsView1.CurrentMode == DetailsViewMode.Insert)
{
((TextBox)DetailsView1.Rows[0].Cells[1].Controls[0]).Text = "Default";
}
}
"
I have tried this with test data and cannot seem to get it to work, the Cell always remains empty, no errors are thrown.
A number of posts suggest you must use template fields, like the following post, I could not get this to work either.
protected void DetailsView1_DataBound(object sender, EventArgs e)
{
if (DetailsView1.CurrentMode == DetailsViewMode.Insert)
{
TextBox tb = (TextBox)DetailsView1.FindControl("TextBox1");
tb.Text = DateTime.Now.ToShortDateString();
}
}
I am thinking this must be so easy and thats why my posts on this site and another go vertually unanswered or its too hard and no one really knows.
|
|
|
|
|
If the Creator said the DataBound event is the best way, then it should be be your choice  . There are a couple of things things that you might want to check:
+ Make sure the execution gets in the body of the if statement in the DetailsView1_DataBound event handler, I just want to ensure that your code does assign the default value to the input textbox.
+ Make sure you get reference to the right input textbox to set the default value. For example, make sure you do not assign a value to the input textbox of the BoundField or TemplateField with the InsertVisible property is set to false.
+ Make sure the Text property of the input textbox is not overwritten somewhere else.
Basically, when you get reference to the textbox with the DefailsView is in the Insert mode, you'll have 2 common options:
+ Use the rowindex and cellindex values, for example when you use the BoundField in the DetailsView control.
+ Use the FindControl method, and you use this way when define a TemplateField in the DetailsView control.
Perhaps, if you still cannot figure out the root cause, you might want to post your code snippets, that might help. In addition, I don't know off any book containing lots of examples about the GridView, DetailsView controls, but you may find online from the sites:
http://www.gridviewgirl.com[^]
http://www.gridviewguy.com/[^]
|
|
|
|
|
Thankyou for your patience, I will keep chipping away at it and take on board your suggestions. I have been trolling the Net on and off for a couple weeks and am pleased I am not the only one in this prediciment. Both the Gridviewguy and Gridviewgirl sites are good and I have seen posts from Gridviewguy assisting on forums but unless I missed something I could not see an example of what I am doing.
Scott Mitchell (www.4guysfromrolla.com) also has contributed some good examples to the Microsoft MSDN site at the following link.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/GridViewEx.asp
Scott has also contributed a number of good articles for Microsoft under learn at
www.asp.net
There are 13 articles with more coming and can they be downloaded as PDF files
At the moment I am compiling eveything I have trolled up and will go through it again in case I have missed something. I am trying to teach myself C# ASP.NET whilst building an in house application. My previous backgroud dates back to the xbase dos pre Windows days and then some early db work in Delphi and object pascal, so I am starting from scratch.
Thanks Again
Kim
|
|
|
|
|
How to perform email validaiton for windows applicaions in .net
|
|
|
|
|
Try this.
I think it will help you.
using System.Text.RegularExpressions;
public static bool CheckEmailAddress(string strText)
{
//Validates the Email address
string strPattern = @"^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@(([0-9a-zA-Z])+([-\w]*[0-9a-zA-Z])*\.)+[a-zA-Z]{2,9})$";
return CheckRegExPattern(strPattern, strText.Trim());
}
public static bool CheckRegExPattern(string strPattern, string strText)
{
return Regex.IsMatch(strText.Trim(), strPattern);
}
|
|
|
|
|
HI Suamal,
Thnak u for the help.It worked out.
bye
Uma
|
|
|
|
|
You can also try this piece of code.
Assumptions:
1. Your Windows form has a text box with the name txtEmailID
2. You have using System.Text.RegularExpressions at the top of your form.
3. Call the ValidateEmail function in the event where you want to validate the email id.
private bool ValidateEmail()
{
bool checkFlag = false;
string EmailID = txtEmailID.Text.Trim();
if (EmailID != "")
{
Regex regex = new Regex(@"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");
Match match = regex.Match(EmailID);
if (match.Length == EmailID.Length)
{
checkFlag = true;
}
else
{
MessageBox.Show("Enter a valid email-id");
checkFlag = false;
txtEmailID.Focus();
}
}
else
{
MessageBox.Show("Enter Email ID");
txtEmailID.Focus();
}
return checkFlag;
}
All the best.
Siddharth P
|
|
|
|
|
Hi Siddharth P,
Thank u for the help.
Uma
|
|
|
|
|
what about this tell me clear
suresh babu.k
|
|
|
|
|
i dont knowddd
suresh babu.k
|
|
|
|
|
dfgdsfgdfdghrtydfg
suresh babu.k
|
|
|
|
|
dhgfghfhfhf
suresh babu.k
|
|
|
|
|
fdsfsdtertdfdtert
suresh babu.k
|
|
|
|
|
|
Hai, getting ignored for the third time. If I am wrong on any part, please let me know. If you think I do not contribute and only ask, that's because I am not proficient enough to help. Shall wait for a lil longer. Anyway, thanks those who helped me before. And rest assured that I am not a student studying asp.net, I am working and currently helping ppl out.
------------------------------------------------------------------------------------------------
Hi all,
I am trying to send email from my website. If you use the createuserwizard tools from VS studio 2005, you have this mail definition as one of it's property. I want to send email through that to my registered user. I typed the following code into my web.config file.
<system.net>
<mailSettings>
<smtp from="k@hot.com">
<network host="mhub.n.edu" port="25" password="" userName="" defaultCredentials="True" />
</smtp>
</mailSettings>
</system.net>
Is the code correct? Because everytime I try to send email after registration, I get a "A socket operation was attempted to an unreachable network" error. Could it be my email server?
Btw, I changed my host name to prevent ppl from abusing it. Any Ideas? Thank in advance.
-=Kenzy=-
-- modified at 5:45 Friday 16th June, 2006
|
|
|
|
|
can anyone help in writing random password generation code in C#.
|
|
|
|
|
Check this ^
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it! 
|
|
|
|
|
Or just use the randomizer, but not the default (that will generate the same number every second).
Use the Random( (int)DateTime.Now.Ticks );
public static string GeneratePassword(int length)
{
string allowebChars = "abcdefghijkmnopqrstuvwxyzABCDEFGHJKLMNOPQRSTUVWXYZ0123456789";
Random rnd = new Random( (int)DateTime.Now.Ticks );
char[] chars = new char[length];
for (int i = 0; i<length; i++)
{
chars[i] = allowebChars[ rnd.Next( allowedChars.Length ) ];
}
return new string(chars);
}
regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
|
|
|
|
|
I've had several posts here and there. I am VERY green so if someone can point me in the right direction.
I have an app where the user enters a part number. A datagrid comes back with info based on what the user entered. Okay, that part I have down.
Question 1: I want the screen to come back and say 'no part exists' and display a BLANK ROW where the user can start to enter information about the new part number. How do I do this?
Question 2: I found an article here that discussed using a reusable databinding function. Based on some other feedback here it got tweeked. It requires two parameters:
private void BindGrid (SqlCommand command, System.Web.UI.WebControls.DataGrid DGrid)<br />
{<br />
SqlDataAdapter adapter = new SqlDataAdapter(command);<br />
DataSet ds = new DataSet();<br />
adapter.Fill(ds);<br />
DGrid.DataSource = ds;<br />
DGrid.DataBind();<br />
<br />
}
So for example, when I click the button to retrieve the data, I call it like this:
private void btnSearch2_Click(object sender, System.EventArgs e)<br />
{<br />
strPartNumberInput2 = txtSearchPart2.Text;<br />
string SQLString = "SELECT c.cost, pt.description, dd.DrawingNumber, dd.DrawingRevision, dd.DwgPath FROM costs c INNER JOIN Parts p ON c.PartID = p.Id INNER JOIN PartTypes pt on pt.ID = p.PartTypeID LEFT JOIN DraftingData dd on dd.PartID = p.ID WHERE p.PartNumber = @PartID";<br />
SqlCommand cmd = new SqlCommand();<br />
cmd.Connection = new SqlConnection(strConnectSQL);<br />
cmd.CommandText = SQLString;<br />
cmd.Parameters.Add ("@PartID", strPartNumberInput2);<br />
BindGrid(cmd, DataGrid2);<br />
}
Now I'm getting into the edit, update, cancel functions (again looking at documentation out there) such as:
public void DataGrid2_edit (object sender, DataGridCommandEventArgs e)
{<br />
DataGrid2.EditItemIndex = e.Item.ItemIndex;<br />
BindGrid();<br />
}In this example there are no parameters.
How would I pass the parameters? Do I have to repeat all the sql command and connection stuff each time?
|
|
|
|
|
Hi.
I have an application which requires a secure channel for just certain pages. I was able to do this selectively in IIS with no problem, except that the (non-secure) custom error page I defined in my web.config no longer works when an exception is thrown in one of the secure pages. It wants me to authenticate (even though these pages are set to allow anonymous access), after which I'll get the standard access is denied error.
I tried setting the defaultRedirect property in the web.config file to include the full Url, i.e., defaultRedirect="https://myDomain/myApp/genericErrorPage.htm", but then the non-secure pages have trouble accessing the custom error page. I get an HTTP 401.2 error:
"You do not have permission to view this directory or page using the credentials that you supplied because your Web browser is sending a WWW-Authenticate header field that the Web server is not configured to accept."
Is there a way to have non-secure and secure pages within the same app, while using custom error pages?
|
|
|
|
|
Please could anyone help me out on this.
I need HTML code to store multiple file name in the database when multiple browse buttons are used.
the HTML page should have multiple browsers, for example Prof Signature field will have one browse button and Dean Signature field will have another browse button, the values selected values of these two should be stored in the database.
|
|
|
|
|
please help me to get data into dropdownlist from the database table.
|
|
|
|
|
SqlConnection c = new SqlConnection(stringconection);<br />
c.Open();<br />
DataSet ds = new DataSet();<br />
SqlDataAdapter da= new SqlDataAdapter ("select command",c);<br />
da.Fill(ds);<br />
Dropdownlist1.DataSource = ds.Tables[0];<br />
Dropdownlist1.DataValueField = "Column1";<br />
Dropdownlist1.DataTextField = "Column2";<br />
c.Close();
|
|
|
|
|
Goto DropdownList's properties and DataValueField put the PK of Database and DataTextField put the column name which u want to display form Database.
Then Write Method as:
DataSet ds = GetValuesFromDB();
DropdownList1.DataSource = ds;
DropdownList1.DataBind();
ListItem lst = new ListItem("All Values", "0");
DropdownList1.Items.Insert(0, lst);
Where GetValuesFromDB() will contain sql which will return Dataset.The query will have PK and the column name which u want to display.
I hope this will help u.
Thanks and Regards.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
