Re: string - ASP.NET Discussion Boards

tonymathewt13-Sep-07 17:35

13-Sep-07 17:35

I have a transaction that adds sql statements between postbacks that occur at specific button clicks. And the transaction is finally commited at another button click.
Each time the postback occurs the sql commands are added to the transaction without any problem but finally when i commit it, an exception occurs that says:

"This SqlTransaction is completed; it is no longer usable."

When I viewed the property of the transaction object while debugging I ve noticed a Timeout property that has the value 15. I dont know whether it is in seconds or minutes. I think it is due to the timeout the transaction is gettting completed.

I have declared the transaction globally in my page say "MemberLinking.aspx" as:

<br />
Private Shared myTrans As SqlTransaction<br />

I have then passed the transaction to a function defined in a class file like this:

<br />
Public Sub BeginTransaction(ByRef tsql As SqlTransaction)<br />
        Try<br />
            tsql = conn.BeginTransaction()<br />
        Catch ex As Exception<br />
        Finally<br />
        End Try<br />
End Sub<br />

This function begins the transaction. The other functions that adds the commands to the transaction are also passed the transaction as parameter. Vut it is done by value.
I have added the sql statements to the transaction as:

<br />
sqlstatement = "UPDATE UserFamily SET UserID=" & LinkedUID & " WHERE UserID=" & UID & " AND FamilyID=" & FID<br />
cmd = ReturnSqlCommand(sqlstatement)<br />
cmd.Transaction = Mytrans<br />
cmd.ExecuteNonQuery()<br />
<br />
sqlstatement = "INSERT INTO UserFamily(UserID,FamilyID,Accepted,IsModerator) VALUES (" & ChildID & "," & FamilyID & _<br />
                            ",1,0)"<br />
cmd = ReturnSqlCommand(sqlstatement)<br />
cmd.Transaction = Mytrans<br />
cmd.ExecuteNonQuery()<br />

where ReturnSqlCommand() is a function that takes as string a parameter and returns it as an SqlCommand object. The above two are not the only statements. The application adds a set of statements at each postbacks. Through out this process there is no error or exception utill i try to commit or rollback the transaction object.

Re: SqlTransaction between postbacks

Steve Echols13-Sep-07 18:52

Steve Echols

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

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