Re: Delete row from GridView which is bound to DataTable - ASP.NET Discussion Boards

deepaks327-Jun-07 8:38

27-Jun-07 8:38

Hi Friends,
I have problem sending mail through ASP.Net.
whenever i try to send the mail from my server for which i have passed the details like smtp server and from address , i get an error that :

Mailbox unavailable. The server response was: <myemail@gmail.com> No such user here
But i have specified the from email address of my smtp server.
I have no clue that why is it searching for a gmail address on the smtp server.

I hope i am able to state my question/problem.

Thanks in advance.

Deepak Surana

Re: Sending Mail Problem.

Christian Graus27-Jun-07 10:55

Christian Graus

27-Jun-07 10:55

What makes you think it's searching for gmail ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Sending Mail Problem.

deepaks327-Jun-07 18:02

deepaks3

27-Jun-07 18:02

I was debugging the code and after the send mail function it throws an exception.
This is where i got to know it is searching for the other address

Deepak Surana

Help needed in performing validation

gayathri_it200527-Jun-07 7:39

gayathri_it2005

27-Jun-07 7:39

hi friends

i should do server side validation on two controls
by making use of if condition in aps.net 1.1

i should not use any validation controls instead i should make use of
if..else condition for performing validation..

i have a textbox and a drop down list box..
text box has new entry
dropdown list box has selected items present in it
now i should write the coding for validating as such user
can enter new one or can select one...

please suggest me the solution for this

regards,
gayathri

--------------------------------------------------------------------------------

Re: Help needed in performing validation

Not Active27-Jun-07 8:21

Not Active

27-Jun-07 8:21

Sounds like homework to me. What have you tried so far?

only two letters away from being an asset

HttpWebRequest

dekart_roo27-Jun-07 5:51

dekart_roo

27-Jun-07 5:51

I have a script that I can post to via a simple html form, but I can't figure out how to replicate the results with HttpWebRequest. Is there a way of getting the full functionality of a form submit via the HttpWebRequest?

Works:

Does not Work:
ASCIIEncoding encoder = new ASCIIEncoding();

string ifxLoc = "http://script-to-submit-to/login.dll?login";
string postData = "UserName=" + unme;
postData += "&PassWord=" + upswd;

byte[] data = encoder.GetBytes(postData);

HttpWebRequest s2oReq = (HttpWebRequest) WebRequest.Create(ifxLoc);
s2oReq.Method = "POST";
s2oReq.AllowAutoRedirect = true;
s2oReq.ContentType = "application/x-www-form-urlencoded";
s2oReq.ContentLength = data.Length;

Stream s2oStream = s2oReq.GetRequestStream();
s2oStream.Write(data, 0, data.Length);
s2oStream.Close();

Problem:
The HttpWebRequest seems to make a shallow connection to the login.dll, or doesn't fully follow through. I can't get it...working... in any way. It just returns the input of the html of the login page. Am I going about it in the wrong manner?

I also need a way to impliment the native redirect that's built into the simple form submit. If I use a response.redirect() after closing the stream, it is not the same.

Thanks!
-Roo

Delete row from GridView which is bound to DataTable [modified]

kjosh27-Jun-07 5:15

kjosh

27-Jun-07 5:15

Hi,
I have the Gridview which is bound to DataTable. In the GridView I have one button Delete for each row , when clicking on button the row need to be deleted from gridview.
private void BindGrid()
{
GridView1.DataSource = GetDataSource();
GridView1.DataBind();
}

protected System.Data.DataTable GetDataSource()
{
// const string key = "MyDataSource";
System.Data.DataTable aTable = new System.Data.DataTable();
aTable = (System.Data.DataTable)Session["dta"] ;

if (aTable == null)
{
aTable = CreateDataTableA(); -- In this CreateTable I am creating one DataTable and returning it.
Session["dta"] = aTable;

}
return aTable;

}

protected void GridView1_RowDeleting(object sender,GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32( (GridView1.Rows[e.RowIndex].Cells[0].Text.ToString())); -- This statement containg null value always. This is giving exception because of this Null value.
FindRowByID(id).Delete();
BindGrid();
}

private DataRow FindRowByID(int id)
{
DataRow[] rows = GetDataSource().Select("District_ID = " + id.ToString());
return rows[0];
}
How to get the row’s cell value when delete button is clicked.

My Gridview syntax is like this:
<asp:gridview id="GridView1" runat="server" autogeneratecolumns="False" onrowdeleting="GridView1_RowDeleting">
<columns>
<asp:templatefield headertext="District_ID">
<edititemtemplate>
<asp:textbox id="TextBox1" runat="server">

<itemtemplate>
<asp:label id="Label1" runat="server" text="<%# DataBinder.Eval(Container.DataItem, "District_ID") %>" width="115px">

<asp:templatefield headertext="District_Name">
<edititemtemplate>
<asp:textbox id="TextBox2" runat="server">

<itemtemplate>
<asp:label id="Label2" runat="server" text="<%# DataBinder.Eval(Container.DataItem, "District_Name") %>">

<asp:commandfield buttontype="Button" deletetext="-" showdeletebutton="True" showheader="True">

Thanks in advance.

-- modified at 11:32 Wednesday 27th June, 2007

Re: Delete row from GridView which is bound to DataTable

Urs Enzler27-Jun-07 8:34

Urs Enzler

27-Jun-07 8:34

I suggest using an ObjectDataSource as an mediator between the GridView and the DataTable.

ObjectDataSource makes deleting, inserting, updating much easier.

Please read about using the ObjectDataSource an MSDN.
There are also quite a lot samples you can find using google (search terms: GridView ObjectDataSource)

Good luck
Urs

-^-^-^-^-^-
no risk no funk

Values in array

afreshpulse27-Jun-07 4:45

afreshpulse

27-Jun-07 4:45

I have a site where a user can input the first part of their post code to see if deliveries can be made to their area. Deliveries are only available in one area, so I use the following code:

	Private Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click<br />
<br />
		Dim al As New ArrayList()<br />
		Dim i As Integer<br />
<br />
		For i = 1 To 32<br />
			al.Add("BS" & i)<br />
		Next i<br />
<br />
		Dim postCode = Me.txtPostCode.Text<br />
<br />
		Dim idx As Integer = al.BinarySearch(postCode, New CaseInsensitiveComparer())<br />
<br />
		If idx > 0 - 1 Then<br />
			Me.litMsg.Text = "We can collect from you"<br />
		Else<br />
			Me.litMsg.Text = "We do not collect from your area"<br />
		End If<br />
<br />
	End Sub

This finds the first postcode, but none of the others. Is there something wrong in the code? Should I just use a database table and pull values from there instead?

Damian

Re: Values in array

RichardGrimmer27-Jun-07 5:45

RichardGrimmer

27-Jun-07 5:45

Couldn't you use the following if you're only supporting one delivery area:

<br />
<br />
string str = txtPostcode.text;<br />
if (str.StartsWith ("BS"))<br />
 ...<br />
else<br />
...<br />

"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)

Re: Values in array

afreshpulse27-Jun-07 6:24

afreshpulse

27-Jun-07 6:24

Hi Richard, thanks for responding.

I could use the StartsWith method (which works), However, the postcodes range from BS1 to BS32. So if a user types 'BS43' they still get the 'We can collect from you' message.

Any thoughts?

Damian

Re: Values in array

Urs Enzler27-Jun-07 8:40

Urs Enzler

27-Jun-07 8:40

Put all valid postcodes into an List<string> and use the Contains method:

List<string> postalcodes = new List<string>();

// add all codes
postalcodes.Add("BS1");
...

if (postalcodes.Contains(TextBox.Text))
...
else
...

-^-^-^-^-^-
no risk no funk

Re: Values in array

RichardGrimmer27-Jun-07 9:38

RichardGrimmer

27-Jun-07 9:38

Yeah - what he said lol...

"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)

No. of hites facility in my website

pathak7827-Jun-07 4:42

pathak78

27-Jun-07 4:42

I want to give facility of no. of hites in my site.

If any one have some idea about this.

please give me some source code.

Thanks,

Pathak

Re: No. of hites facility in my website

Christian Graus27-Jun-07 11:00

Christian Graus

27-Jun-07 11:00

You can store this in a file or in the database. Store a number, have code that increments the number called when a page is being served.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: No. of hites facility in my website

Vasudevan Deepak Kumar27-Jun-07 21:40

Vasudevan Deepak Kumar

27-Jun-07 21:40

Check out http://www.hotscripts.com/[^] for counters in different languages.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Property value after PostBack of UserControl

ZeedijkMike27-Jun-07 4:41

ZeedijkMike

27-Jun-07 4:41

Hi Allm

I have created a MaskedTextBox UserControl with a number of properties (Value, MinValue, MaxValue etc.) The UserControl works but I am not able to actually get the Value from the UserControl in the main apsx page. In short what I have done:

UserControl with a TextBox, a RangeValidator and some JavaScript to take care of the formatting.

In the main page:

<uc1:MaskedTextBox ID="MaskedTextBox2" runat="server" MinValue="-10000" MaxValue="10000" ErrorMessage="Value must be between {0} and {1}" Required="true" Display="None" /><br />
<br /><br />
<asp:Button ID="Button1" runat="server" Text="Button" /></div><br />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><br />

And in the code behind on_load event:

<br />
    protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        if (Page.IsPostBack)<br />
        {<br />
            Label2.Text = MaskedTextBox2.TextValue.ToString();<br />
        }<br />
    }<br />

But the value of the TextValue property is not available because the UserControl is loaded after the Page_Load event. How do I get the TextValue of the UserControl in the PostBack of the aspx page?
I would prefer not to use Session or ViewState because I would like to use the UserControl as I would use a 'normal' TextBox. Any ideas out there?

Kind regards,

Mike

Re: Property value after PostBack of UserControl

ZeedijkMike27-Jun-07 4:43

ZeedijkMike

27-Jun-07 4:43

Woops sorry for the double post Unsure | :~

Mike

Re: Property value after PostBack of UserControl

SHatchard27-Jun-07 5:28

SHatchard

27-Jun-07 5:28

If you want to do this I would suggest using an event

In your class

Public Event TextChanged(byval sender as object, byval e as eventargs)

Then pick up the text changed and bubble it

Public Sub textbox1_TextChanged(byval sender as object, byval e as eventargs) handles textbox1.textchanged
raiseevent textchanged(me, e)
end sub

Then you can use the event as normal within your aspx page.

If you need clarification please let me know

Re: Property value after PostBack of UserControl

ZeedijkMike27-Jun-07 5:56

ZeedijkMike

27-Jun-07 5:56

Thanks for the reply.

I'll try you solution. It looks somewhat better than the the solution I came up with my self. I try to dig in to the UserControl to get the value like this;

Label1.Text = (MaskedTextBox1.Controls[2] as TextBox).Text;

But working with events seems to be a more proper way.

Thanks,

Mike

Re: Property value after PostBack of UserControl

Urs Enzler27-Jun-07 8:44

Urs Enzler

27-Jun-07 8:44

What is causing the postback? I assume the Button.

Put your code in the event handler of the postback initiator instead of the load event handler. That would then be the Button_Click event handler if my assumption is right.

Happy Programming
Urs

-^-^-^-^-^-
no risk no funk

Retrieving Property value after PostBack of UserControl

ZeedijkMike27-Jun-07 4:39

ZeedijkMike

27-Jun-07 4:39

<uc1:MaskedTextBox ID="MaskedTextBox2" runat="server" MinValue="-10000" MaxValue="10000" ErrorMessage="Value must be between {0} and {1}" Required="true" Display="None" /><br />
<br /><br />
<asp:Button ID="Button1" runat="server" Text="Button" /></div><br />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><br />

And in the code behind on_load event:

<br />
    protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        if (Page.IsPostBack)<br />
        {<br />
            Label2.Text = MaskedTextBox2.TextValue.ToString();<br />
        }<br />
    }<br />

Mike

Re: Retrieving Property value after PostBack of UserControl

Venkatesh Mookkan27-Jun-07 17:38

Venkatesh Mookkan

27-Jun-07 17:38

Can you post the code used for the TextValue property? Use ViewState for the TextValue property. I believe you must be using String variable instead.

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot

SQL Query works intermittently...

TenmanS1427-Jun-07 4:39

TenmanS14

27-Jun-07 4:39

For some reason the code below to fill a datagridview works very intermittently, I was wondering if anyone could spot any coding horrors my inexperience may have allowed in there...

dateFrom = "CONVERT(DateTime, '01/" & MonthDD.SelectedIndex + 1 & "/" & Trim(YearDD.SelectedValue) & "', 103)"

If MonthDD.SelectedValue <> "December" Then
dateTo = "CONVERT(DateTime, '01/" & MonthDD.SelectedIndex + 2 & "/" & Trim(YearDD.SelectedValue) & "', 103)"
Else
dateTo = "CONVERT(DateTime, '01/01/" & Trim(YearDD.SelectedValue + 1) & "', 103)"
End If

SQLString1 = "SELECT [InvoiceNo], [ClientCode], [Date], [PnrCode], [Initials], [Amount], [AccyNC4000], [DisbsNC4090], [DKpgmgmtNC4050], [CorpTaxNC4021], [PersTaxNC4030], [PayrollNC4070], [ExectrustNC4031], [CoySecNC4010], [OtherNC4080], [AccyNC4000]+[DisbsNC4090]+[DKpgmgmtNC4050]+[CorpTaxNC4021]+[PersTaxNC4030]+[PayrollNC4070]+[ExectrustNC4031]+[CoySecNC4010]+[OtherNC4080] as [Total] FROM [transaction] WHERE ("

If PartnerDD.SelectedItem.Value <> 0 Then
SQLString1 = SQLString1 & "([PnrCode] = @PnrCode) AND "
End If

If ClientCodeDD.SelectedItem.Text <> "Select a Client Code" Then
SQLString1 = SQLString1 & "([ClientCode] = @ClientCode) AND "
End If

SQLString1 = SQLString1 & "([Date] >= " & dateFrom & ") AND ([Date] < " & dateTo & "))"

SqlDataSource1.SelectCommand = SQLString1

Re: SQL Query works intermittently...

Colin Angus Mackay27-Jun-07 5:12

Colin Angus Mackay

27-Jun-07 5:12

TenmanS14 wrote:
I was wondering if anyone could spot any coding horrors my inexperience may have allowed in there...

You should use paramertised queries rather than injecting values in to the SQL. See SQL Injection Attacks and tips on how to prevent them[^]... Actually later on you are using parameters! OMG | :OMG:

Why use two different ways of doing things?

Other than that I can't really see what you are trying to do. The code is quite difficult to read.

Perhaps you need to isolate this SQL and see how it runs on its own with various inputs to see if you can determine where exactly it is failing.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Ready to Give up - Your help will be much appreciated.

My website

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.