Search Button - ASP.NET Discussion Boards

Re: Problem with filepath while reading to filestream

Sandeep Akhare13-Sep-07 20:57

Sandeep Akhare

13-Sep-07 20:57

i think no need to save also give one of the steamreader parameter as uploadfileCntrolID.Postedfile.InputStream

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Re: Problem with filepath while reading to filestream

Blue_Boy13-Sep-07 21:05

Blue_Boy

13-Sep-07 21:05

It was my quick answer

Addition in my previous post: After the job is done with file then file can be deleted

FileInfo fdelete = new FileInfo(Server.MapPath("~/UplDoc/filename.extension"));<br />
fdelete.Delete();

I Love SQL

adding a property in the class

I Never Look Behind13-Sep-07 17:50

I Never Look Behind

13-Sep-07 17:50

Hi All!
in my application, there is a table tblCountries(countryId,countryName) & i have a class: person

public class Person
{
private string name;
private int countryID;

public string Name
{
get {return this.name;}
set {this.name = value;}
}

public string CountryId
{
get {return this.countryID;}
set {this.countryID= value;}
}

}

now i want to add an property CountryName which returns name of the country name rather than country . can any one help me in this regards?

Re: adding a property in the class

Steve Echols13-Sep-07 18:39

Steve Echols

13-Sep-07 18:39

Smells like homework, but...

Check out DataTable.Select.

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

SqlTransaction between postbacks

tonymathewt13-Sep-07 17:35

tonymathewt

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

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