how to create a data entry table? - ASP.NET Discussion Boards

Steve Echols13-Sep-07 18:52

13-Sep-07 18:52

AFAIK: Everytime you postback, your page and all it's code behind variables are recreated and reinitialized, but controls retain their values because of the magical viewstate.

SqlTransaction doesn't have any concept of viewstate, so it's a fresh new SqlTransaction each time.

- S
50 cups of coffee and you know it's on!

Re: SqlTransaction between postbacks

tonymathewt13-Sep-07 21:03

tonymathewt

13-Sep-07 21:03

Thank you Steve
Is it anyway possible to preserve the transaction b/w postbacks? Is there any chance of transaction getting timed out?

Search Button

Amit Kumar G13-Sep-07 13:51

Amit Kumar G

13-Sep-07 13:51

Hello,

In my internet site, i have to proivde search functionality within the website domain. Could you please give some light where should i look for related articles,sample code, ideas etc....

Thanks,

Thanks

Re: Search Button

Imran Khan Pathan13-Sep-07 18:30

Imran Khan Pathan

13-Sep-07 18:30

Get It Internal Search Engine

Best Regard
Pathan

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

string

seemamltn13-Sep-07 13:31

seemamltn

13-Sep-07 13:31

I have a string
bobby@yahoo.com (Bobby Gill)

I want to parse it and want to get the substring "bobby@yahoo.com" before space.
Could you please give me code.

thanks

seema

Re: string

netJP12L13-Sep-07 17:23

netJP12L

13-Sep-07 17:23

I didn't quite understand what you want. Can you explain a bit more

Re: string

Imran Khan Pathan13-Sep-07 18:20

Imran Khan Pathan

13-Sep-07 18:20

string s="bobby@yahoo.com (Bobby Gill)"<br />
int indx=s.IndexOf(' ');<br />
string val=s.Substring(0,indx);

string s="bobby@yahoo.com (Bobby Gill)"<br />
string[] ss=s.Split(' ');<br />
int count=0;<br />
string val;<br />
foreach(string s1 in ss)<br />
{<br />
if(count==0)<br />
{<br />
val=s1;<br />
}<br />
count=1;<br />
}

Best Regard
Pathan

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

how to create a data entry table?

foobarDividedByZero13-Sep-07 12:43

foobarDividedByZero

13-Sep-07 12:43

Hi all,
I'm trying to make an asp.net data entry table work like they do in access. what i want is a one line table with 3 columns (a time picker, a drop down, and a comments section). When the line is fully populated, I'd like a new empty line to appear below so the user can continue to add any number of lines.

I can't figure out any easy way to do this, and that usually means i'm missing something simple Smile | :)

any help is greatly appreciated!

thanks in advance,
Craig

Re: how to create a data entry table?

Shujaat Ullah Khan13-Sep-07 20:27

Shujaat Ullah Khan

13-Sep-07 20:27

try repeater control or datagrid and add template columns

Shujaat

Validation

seemamltn13-Sep-07 12:39

seemamltn

13-Sep-07 12:39

have a AutoCompleteExtender and I bound it to a textbox. It is the list of
all email address and last name and first name

nMultani@dov.gc.ca (nancy Multani)

bGill@dov.gc.ca (babay Gill)

I want to validate this text box. I want to create new validation control
the text box I type only that item which appear in drop down list or select
valid item or type whole string.

How can I do that.

seema

GridView binding issue [modified]

Vodstok13-Sep-07 10:51

Vodstok

13-Sep-07 10:51

I have a gridview that, depending on the information being passed to it, needs to flag the Visible attribute of a textbox control in one of the template columns. so here is a quick snippet of the datarow as it is being built:

dr[4] = "";
dr[5] = s;
dr[6] = "false";

the datatable columns it references:

dt.Columns.Add("filler");
dt.Columns.Add("key");
dt.Columns.Add("Vis");

and the line in the gridview that is having issues:
<asp:TextBox ID="txtItmQty" runat="server" Text='<%# Bind("filler") %>' Width="42px" Visible='<%# Bind("Vis") %>'></asp:TextBox>

every time i run it, i get this:
<b>Specified cast is not valid.</b>

how or what do i have to pass to the Visible attribute to set this dynamically?

-- modified at 18:14 Thursday 13th September, 2007

______________________
Mr Griffin, eleventy billion is not a number... WTF | :WTF:

-- modified at 18:14 Thursday 13th September, 2007

Re: GridView binding issue

Imran Khan Pathan13-Sep-07 18:56

Imran Khan Pathan

13-Sep-07 18:56

try <%# Eval("filler") %> Instead of <%# Bind("filler") %>

Best Regard
Pathan

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

Re: GridView binding issue [modified]

Jintal Patel13-Sep-07 19:51

Jintal Patel

13-Sep-07 19:51

i m assuming that u store bool value in your "Vis" Field.According to that below solution is given...

public string GetValue(bool Vis)
{
if (Vis)
return "true";
else
return "false";
}

Visible='<%# GetValue(Convert.ToBoolean(DataBinder.Eval(Container.DataItem,"Vis"))) %>'

i thinks this will work

-- modified at 1:56 Friday 14th September, 2007

Jintal Patel

Cookies problem.

Saksida Bojan13-Sep-07 10:32

Saksida Bojan

13-Sep-07 10:32

When i store a cookie, id doesn't remeber even if i use refresh

Using VS2005 SP1

Thank's in advance

Re: Cookies problem.

Guffa13-Sep-07 11:40

Guffa

13-Sep-07 11:40

How do you store the cookie, and how do you try to read it?

---
single minded; short sighted; long gone;

Re: Cookies problem.

Saksida Bojan13-Sep-07 21:28

Saksida Bojan

13-Sep-07 21:28

To Write

// Login.aspx.cs
Response.Cookies["UserName"].Value = txtUserName.Text;
Response.Cookies["UserName"].Expires = core.cookieExpire();
Response.Cookies["Password"].Value = txtPassword.Text;
Response.Cookies["Password"].Expires = core.cookieExpire();

//Class core function cookieExpire

public DateTime cookieExpire()
{
    DateTime dt = DateTime.Now;
    dt.AddYears(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireYear"]));
    dt.AddMonths(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireMonth"]));
    dt.AddDays(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireDay"]));
    dt.AddHours(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireHour"]));
    dt.AddMinutes(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireMinutes"]));
    return dt;
}

//Web.Config
<configuration>
    <appSettings>
        <add key="CookieExpireYear" value="1"/>
        <add key="CookieExpireMonth" value="0"/>
        <add key="CookieExpireDay" value="0"/>
        <add key="CookieExpireHour" value="0"/>
        <add key="CookieExpireMinutes" value="0"/>
    </appSettings>
<connectionStrings>

To Read

//Masterpage.Master.cs

HttpCookie cookieUserName = Request.Cookies["UserName"]; // Both request are null
HttpCookie cookiePassword = Request.Cookies["Password"];

Re: Cookies problem.

Guffa14-Sep-07 7:21

Guffa

14-Sep-07 7:21

Saksida Bojan wrote:
public DateTime cookieExpire()
{
DateTime dt = DateTime.Now;
dt.AddYears(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireYear"]));
dt.AddMonths(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireMonth"]));
dt.AddDays(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireDay"]));
dt.AddHours(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireHour"]));
dt.AddMinutes(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireMinutes"]));
return dt;
}

The methods in the DateTime structure doesn't change the value, they return the new value. That means that the cookieExpire method returns DateTime.Now, which will make your cookies expire immediately.

This will give you a better result:

public DateTime cookieExpire() {
   return DateTime.Now
      .AddYears(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireYear"]))
      .AddMonths(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireMonth"]))
      .AddDays(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireDay"]))
      .AddHours(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireHour"]))
      .AddMinutes(Convert.ToInt32(ConfigurationManager.AppSettings["CookieExpireMinutes"]));
}

---
single minded; short sighted; long gone;

Re: Cookies problem.

Saksida Bojan14-Sep-07 9:22

Saksida Bojan

14-Sep-07 9:22

Thanks for the help.

Validate dates

seemamltn13-Sep-07 9:38

seemamltn

13-Sep-07 9:38

I have a textBox Where I type date. I want to validate it. Im using customValidate controls. I have this function in my code behind page

void DatesValidate(object source, ServerValidateEventArgs e)
{
if (Convert.ToDateTime(e.Value) <= DateTime.Now)
{
e.IsValid = false;
this.lblAddUsers.Text = "The Proxy is already expired";
}
}

<asp:customvalidator id="cvEndDate" runat="server" onservervalidate="DatesValidate"
="" controltovalidate="txtTo" errormessage="error" display="Dynamic">

It is not working it is giving the follo2ing error
'Proxy.DatesValidate(object, System.Web.UI.WebControls.ServerValidateEventArgs)' is inaccessible due to its protection level

seema

Validating the dates

seemamltn13-Sep-07 9:36

seemamltn

13-Sep-07 9:36

seema

Re: Validating the dates

Jon Sagara13-Sep-07 9:39

Jon Sagara

13-Sep-07 9:39

Use the protected access modifier in front of the method declaration. By default, methods are private when specified without an access modifier.

Jon Sagara

Once again, the conservative sandwich-heavy portfolio pays off for the hungry investor! *slurp* Oh, I'm ruined!

-- Dr. Zoidberg

.NET Blog | Personal Blog | Articles

RequiredValidation controls

seemamltn13-Sep-07 7:57

seemamltn

13-Sep-07 7:57

Hi,
I have a asp pase. I have one text box, txtName, txtStartDate, txtEndDate. and a button Submit.I have a grid view hand it has edit, delete and cancel buttons. I want to validate my page.
I have three RequiredValidation controls for three text boxes. I want that error message should only appear when I click on button. But when I click on some where in grid view or when I select any row in grid view it should not show error message.

Thanks.

seema

Re: RequiredValidation controls

Brent Lamborn13-Sep-07 8:42

Brent Lamborn

13-Sep-07 8:42

You will need to toggle the Page_ValidationActive javascript variable similar to what I just outlined here[^].

Only in your case, you probably want to set it to false in the body OnLoad event, and then set it to true in the button's onclick event.

"Half this game is ninety percent mental." - Yogi Berra

If you can read thank a teacher, if you can read in English, thank a Marine.

Re: RequiredValidation controls

Jintal Patel13-Sep-07 20:05

Jintal Patel

13-Sep-07 20:05

hi,

u set ValidationGroup Property of RequiredValidation controls and also for that button on which you want the error message.ValidationGroup should be same for all control

Jintal Patel

Sendin Emails !!!

mrkeivan13-Sep-07 7:29

mrkeivan

13-Sep-07 7:29

Hey guys, I'm trying to make a contact us page for my website and I was reading an article about
that matter http://www.codeproject.com/useritems/EmailApplication.asp
I did exactly as was explained in the article I've added a valid pop3 and SMTP address and
the account which I'm sendin the mail to is also created in my website ! but when I click send I
get this error !

        string Name = TextBox1.Text;<br />
        string Address = TextBox2.Text;<br />
        string Message = TextBox3.Text;<br />
<br />
        SmtpClient SC = new SmtpClient();<br />
        MailMessage Msg = new MailMessage();<br />
<br />
        try<br />
        {<br />
            MailAddress FromAddress = new MailAddress(Address, Name);<br />
            SC.Host = "mail.mla.ir";<br />
            SC.Port = 25;<br />
            Msg.From = FromAddress;<br />
            Msg.To.Add("keivan@mla.ir");<br />
            Msg.Subject = "FeedBack";<br />
            Msg.Body = Message;<br />
            SC.Send(Msg);<br />
        }<br />
        catch (Exception ex)<br />
        {<br />
            Label4.Text = ex.ToString();<br />
        }

System.Net.Mail.SmtpFailedRecipientException: Mailbox unavailable.
The server response was: Verification failed
for at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception)
at System.Net.Mail.SmtpClient.Send(MailMessage message) at ContactMe.Button1_Click(Object sender, EventArgs e)
in (My file)

please help me out !

Thaqnx
Mr.
K

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