trim left 5 character.

Hi guys

I am using vb.net

I have this "12.95-ups ground" string and I need to get the string after the dash

could you send me your suggestions please.

thanks

Cemal

Hi, try this:

Dim myStrAs String ="12.95-ups ground"Dim myTrimAs String = Mid(myStr, InStr(myStr,"-") + 1)

try something like below

index=yourStringVariable.IndexOf(".");

then

YourString.Substring( check what parameter this function requires)
 

string _strTest = "12.95-ups ground";
Response.Write ( _strTest.Substring ( 6 ) ) ;

Thanks

-Mark post(s) as "Answer" that helped you

dim str as string

str="12.95-ups ground"

dim newVal as string

newVal=str.substring(str.indexof("-")+1)

response.write(newVal)

Trouble connecting to an SQL database in C#

Hi guys,

I'm using Visual Web Developer and I've made a GridView and I want to learn how to display information in it (or any other databound control) rather than doing it through the asp source code. I'm using the following code so far, and although I've probably made some errors in it I think there is a problem connecting to the database remotely as I get the following error on the "myConnection.Open()" line.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I tried following the instructions here http://www.datamasker.com/SSE2005_NetworkCfg.htm but didn't have much luck as I don't seem to have the interface shown in the screen prints.

My code so far is

SqlConnection myConnection = new SqlConnection("Server=local;database=WroxUnited");
SqlCommand myCommand = new SqlCommand("SELECT * FROM [Fixtures]", myConnection);

myConnection.Open();

GridView1.DataSource = myCommand.ExecuteReader();
GridView1.DataBind();

myConnection.Close();

Thanks in advance.You specified a server (Local) and a database (WroxUnited) ... just so that we're on the same page, that isn't a remote DB... it's local on your PC.

But the problem is probably because you didn't specify an authentication method... do you intend to use integrated security (using WIndows Authentication) or to use SQL Server Authentication? IF you want integrated securtity then you need to add "Integrated Security=SSPI;" to the connection string otherwise add "Integrated Security=False;User ID=XXXXXX;Password=YYYYYYYY;"

-tg
You can make use of the idea in this code:

SqlConnection sc1 = new SqlConnectionConfigurationManager.ConnectionStrings ["CompanyConnectionString"].ToString ());
SqlDataAdapter sa1 = new SqlDataAdapter();
sc1.Open();
string c = "Select Name , Postion_Name from Employee join Postion on Postion_Num=Postion_ID";
SqlCommand sqc1 = new SqlCommand(c,sc1);
DataSet ds = new DataSet();
sa1.SelectCommand = sqc1;
sa1.Fill(ds);
GridView1.DataSource = ds;
What's annoying is there seems to be so many different ways to go about it, and as I'm just beginning to learn .NET it's all a bit confusing. I'm sure I'll get it eventually but I'm worried I may have already got it but something's not set up correctly to work. However if I do it through ASP source code using a ConnectionString=<%$ConnectionStrings=WroxUnited%> for example then it does work so I suppose it's unlikely to be a problem with the SQL Server set-up.

Just to test that it does actually work would someone be kind enough to post here the smallest amount of code necessary to display data from a database called WroxUnited.mdf stored in the C:, in a gridview called GridView1? Or if it's easier to use another data control then let me know and I'll do it that way.

Thanks for all the help!

Trouble with a simple cookie

Hey guys - hoping you can help me out here. I'm using asp.net 2 (VB) and
trying to set and retrieve values from a cookie. I've done this a few times
before w/o a problem but I seem to be overlooking something here. I'm even
following my previous working examples and I can't see the different.
I have a page that will remember the user's settings using a cookie. Ther
Calendar Events, recent orders, etc will be displayed or hidden based upon
the checkboxes they select (but I haven't gotten that far yet). I'm getting
an error at:
Object reference not set to an instance of an object.
strMyEvents = objCookie.Values("MyEvents")
After using the code below, I tried to search the PC for a cookie and
couldn't find it which makes me think it doesn't exist. Yet, when I
response.redirect the value of the cookie just to test, it indeed finds
"True"
Any ideas'
Here's a simplified version of my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If Page.IsPostBack = False Then
Dim objCookie As HttpCookie
Dim strMyEvents As String
objCookie = Page.Request.Cookies("Intranet")
If IsNothing(objCookie) = True Then
SetCookie("True")
End If
strMyEvents = objCookie.Values("MyEvents")
lblTest.Text = strMyEvents
End If
End Sub
Protected Sub SetCookie(ByVal strMyEvents As String)
Dim objCookie As HttpCookie
objCookie = New HttpCookie("Intranet")
objCookie.Expires = DateTime.MaxValue
objCookie.Values("MyEvents") = "True"
'Response.Redirect(objCookie.Values("MyEvents"))
End SubThe cookie should show up under the domain name you are hitting in your
temporary internet files. You have to refresh the folder after hitting the
page to see the cookie (a bit strange compared to other folders, but many of
the profile folders are not standard windows folders).
You cannot access the cookies until you redirect as the information is not
sent to the server until it is requesting another page. As it works, you are
definitely getting the cookie through.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
****************************************
*********
Think outside the box!
****************************************
*********
"Groove" <noway@.noemail.com> wrote in message
news:%23xgCynXDHHA.4396@.TK2MSFTNGP02.phx.gbl...
> Hey guys - hoping you can help me out here. I'm using asp.net 2 (VB) and
> trying to set and retrieve values from a cookie. I've done this a few
> times before w/o a problem but I seem to be overlooking something here.
> I'm even following my previous working examples and I can't see the
> different.
> I have a page that will remember the user's settings using a cookie. Ther
> Calendar Events, recent orders, etc will be displayed or hidden based upon
> the checkboxes they select (but I haven't gotten that far yet). I'm
> getting an error at:
> Object reference not set to an instance of an object.
> strMyEvents = objCookie.Values("MyEvents")
> After using the code below, I tried to search the PC for a cookie and
> couldn't find it which makes me think it doesn't exist. Yet, when I
> response.redirect the value of the cookie just to test, it indeed finds
> "True"
> Any ideas'
> Here's a simplified version of my code:
>
> Protected Sub Page_Load(ByVal sender As Object, ByVal e As
> System.EventArgs)
> If Page.IsPostBack = False Then
> Dim objCookie As HttpCookie
> Dim strMyEvents As String
> objCookie = Page.Request.Cookies("Intranet")
>
> If IsNothing(objCookie) = True Then
> SetCookie("True")
> End If
>
> strMyEvents = objCookie.Values("MyEvents")
> lblTest.Text = strMyEvents
>
> End If
> End Sub
>
>
> Protected Sub SetCookie(ByVal strMyEvents As String)
> Dim objCookie As HttpCookie
> objCookie = New HttpCookie("Intranet")
> objCookie.Expires = DateTime.MaxValue
> objCookie.Values("MyEvents") = "True"
> 'Response.Redirect(objCookie.Values("MyEvents"))
>
> End Sub
>
Thanks for your help. I've triple checked everything...and still, no
cookie. Can you think of anything that might prevent cookies from being
set? I've never had problems with other sites.
WinXP Pro, IE7.
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@.comcast.netNoSpamM> wrote in
message news:ufUwJXYDHHA.4404@.TK2MSFTNGP03.phx.gbl...
> The cookie should show up under the domain name you are hitting in your
> temporary internet files. You have to refresh the folder after hitting the
> page to see the cookie (a bit strange compared to other folders, but many
> of the profile folders are not standard windows folders).
> You cannot access the cookies until you redirect as the information is not
> sent to the server until it is requesting another page. As it works, you
> are definitely getting the cookie through.
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
> http://gregorybeamer.spaces.live.com
> ****************************************
*********
> Think outside the box!
> ****************************************
*********
> "Groove" <noway@.noemail.com> wrote in message
> news:%23xgCynXDHHA.4396@.TK2MSFTNGP02.phx.gbl...
>
As far as i know there is a limit on the numebr of cookies that can be
set. i thinks its 20. I had this problem a while back. You may need to
do the response.cookies("MainCookie")("Subcookie") to set the values.
I hope this helps
Groove wrote:
> Thanks for your help. I've triple checked everything...and still, no
> cookie. Can you think of anything that might prevent cookies from being
> set? I've never had problems with other sites.
> WinXP Pro, IE7.
>
> --
>
>
>
> "Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@.comcast.netNoSpamM> wrote in
> message news:ufUwJXYDHHA.4404@.TK2MSFTNGP03.phx.gbl...

Trouble with a simple cookie

Hey guys - hoping you can help me out here. I'm using asp.net 2 (VB) and
trying to set and retrieve values from a cookie. I've done this a few times
before w/o a problem but I seem to be overlooking something here. I'm even
following my previous working examples and I can't see the different.

I have a page that will remember the user's settings using a cookie. Ther
Calendar Events, recent orders, etc will be displayed or hidden based upon
the checkboxes they select (but I haven't gotten that far yet). I'm getting
an error at:

Object reference not set to an instance of an object.
strMyEvents = objCookie.Values("MyEvents")

After using the code below, I tried to search the PC for a cookie and
couldn't find it which makes me think it doesn't exist. Yet, when I
response.redirect the value of the cookie just to test, it indeed finds
"True"

Any ideas??

Here's a simplified version of my code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)

If Page.IsPostBack = False Then

Dim objCookie As HttpCookie
Dim strMyEvents As String

objCookie = Page.Request.Cookies("Intranet")

If IsNothing(objCookie) = True Then
SetCookie("True")
End If

strMyEvents = objCookie.Values("MyEvents")

lblTest.Text = strMyEvents

End If

End Sub

Protected Sub SetCookie(ByVal strMyEvents As String)

Dim objCookie As HttpCookie

objCookie = New HttpCookie("Intranet")
objCookie.Expires = DateTime.MaxValue

objCookie.Values("MyEvents") = "True"

'Response.Redirect(objCookie.Values("MyEvents"))

End SubThe cookie should show up under the domain name you are hitting in your
temporary internet files. You have to refresh the folder after hitting the
page to see the cookie (a bit strange compared to other folders, but many of
the profile folders are not standard windows folders).

You cannot access the cookies until you redirect as the information is not
sent to the server until it is requesting another page. As it works, you are
definitely getting the cookie through.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
*************************************************
Think outside the box!
*************************************************
"Groove" <noway@.noemail.comwrote in message
news:%23xgCynXDHHA.4396@.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

Hey guys - hoping you can help me out here. I'm using asp.net 2 (VB) and
trying to set and retrieve values from a cookie. I've done this a few
times before w/o a problem but I seem to be overlooking something here.
I'm even following my previous working examples and I can't see the
different.
>
I have a page that will remember the user's settings using a cookie. Ther
Calendar Events, recent orders, etc will be displayed or hidden based upon
the checkboxes they select (but I haven't gotten that far yet). I'm
getting an error at:
>
Object reference not set to an instance of an object.
strMyEvents = objCookie.Values("MyEvents")
>
After using the code below, I tried to search the PC for a cookie and
couldn't find it which makes me think it doesn't exist. Yet, when I
response.redirect the value of the cookie just to test, it indeed finds
"True"
>
Any ideas??
>
Here's a simplified version of my code:
>
>
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs)
>
If Page.IsPostBack = False Then
>
Dim objCookie As HttpCookie
Dim strMyEvents As String
>
objCookie = Page.Request.Cookies("Intranet")
>
>
If IsNothing(objCookie) = True Then
SetCookie("True")
End If
>
>
strMyEvents = objCookie.Values("MyEvents")
>
lblTest.Text = strMyEvents
>
>
End If
>
End Sub
>
>
>
>
>
Protected Sub SetCookie(ByVal strMyEvents As String)
>
Dim objCookie As HttpCookie
>
objCookie = New HttpCookie("Intranet")
objCookie.Expires = DateTime.MaxValue
>
objCookie.Values("MyEvents") = "True"
>
'Response.Redirect(objCookie.Values("MyEvents"))
>
>
End Sub
>

Thanks for your help. I've triple checked everything...and still, no
cookie. Can you think of anything that might prevent cookies from being
set? I've never had problems with other sites.

WinXP Pro, IE7.

--

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@.comcast.netNoSpamMwrote in
message news:ufUwJXYDHHA.4404@.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

The cookie should show up under the domain name you are hitting in your
temporary internet files. You have to refresh the folder after hitting the
page to see the cookie (a bit strange compared to other folders, but many
of the profile folders are not standard windows folders).
>
You cannot access the cookies until you redirect as the information is not
sent to the server until it is requesting another page. As it works, you
are definitely getting the cookie through.
>
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
>
*************************************************
Think outside the box!
*************************************************
"Groove" <noway@.noemail.comwrote in message
news:%23xgCynXDHHA.4396@.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

>Hey guys - hoping you can help me out here. I'm using asp.net 2 (VB) and
>trying to set and retrieve values from a cookie. I've done this a few
>times before w/o a problem but I seem to be overlooking something here.
>I'm even following my previous working examples and I can't see the
>different.
>>
>I have a page that will remember the user's settings using a cookie.
>Ther Calendar Events, recent orders, etc will be displayed or hidden
>based upon the checkboxes they select (but I haven't gotten that far
>yet). I'm getting an error at:
>>
>Object reference not set to an instance of an object.
>strMyEvents = objCookie.Values("MyEvents")
>>
>After using the code below, I tried to search the PC for a cookie and
>couldn't find it which makes me think it doesn't exist. Yet, when I
>response.redirect the value of the cookie just to test, it indeed finds
>"True"
>>
>Any ideas??
>>
>Here's a simplified version of my code:
>>
>>
>Protected Sub Page_Load(ByVal sender As Object, ByVal e As
>System.EventArgs)
>>
> If Page.IsPostBack = False Then
>>
> Dim objCookie As HttpCookie
> Dim strMyEvents As String
>>
>objCookie = Page.Request.Cookies("Intranet")
>>
>>
>If IsNothing(objCookie) = True Then
> SetCookie("True")
>End If
>>
>>
>strMyEvents = objCookie.Values("MyEvents")
>>
>lblTest.Text = strMyEvents
>>
>>
>End If
>>
>End Sub
>>
>>
>>
>>
>>
>Protected Sub SetCookie(ByVal strMyEvents As String)
>>
>Dim objCookie As HttpCookie
>>
>objCookie = New HttpCookie("Intranet")
>objCookie.Expires = DateTime.MaxValue
>>
>objCookie.Values("MyEvents") = "True"
>>
>'Response.Redirect(objCookie.Values("MyEvents"))
>>
>>
>End Sub
>>

>
>

As far as i know there is a limit on the numebr of cookies that can be
set. i thinks its 20. I had this problem a while back. You may need to
do the response.cookies("MainCookie")("Subcookie") to set the values.

I hope this helps

Groove wrote:

Quote:

Originally Posted by

Thanks for your help. I've triple checked everything...and still, no
cookie. Can you think of anything that might prevent cookies from being
set? I've never had problems with other sites.
>
WinXP Pro, IE7.
>
>
--
>
>
>
>
>
>
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@.comcast.netNoSpamMwrote in
message news:ufUwJXYDHHA.4404@.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

The cookie should show up under the domain name you are hitting in your
temporary internet files. You have to refresh the folder after hitting the
page to see the cookie (a bit strange compared to other folders, but many
of the profile folders are not standard windows folders).

You cannot access the cookies until you redirect as the information is not
sent to the server until it is requesting another page. As it works, you
are definitely getting the cookie through.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
*************************************************
Think outside the box!
*************************************************
"Groove" <noway@.noemail.comwrote in message
news:%23xgCynXDHHA.4396@.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

Hey guys - hoping you can help me out here. I'm using asp.net 2 (VB) and
trying to set and retrieve values from a cookie. I've done this a few
times before w/o a problem but I seem to be overlooking something here.
I'm even following my previous working examples and I can't see the
different.
>
I have a page that will remember the user's settings using a cookie.
Ther Calendar Events, recent orders, etc will be displayed or hidden
based upon the checkboxes they select (but I haven't gotten that far
yet). I'm getting an error at:
>
Object reference not set to an instance of an object.
strMyEvents = objCookie.Values("MyEvents")
>
After using the code below, I tried to search the PC for a cookie and
couldn't find it which makes me think it doesn't exist. Yet, when I
response.redirect the value of the cookie just to test, it indeed finds
"True"
>
Any ideas??
>
Here's a simplified version of my code:
>
>
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs)
>
If Page.IsPostBack = False Then
>
Dim objCookie As HttpCookie
Dim strMyEvents As String
>
objCookie = Page.Request.Cookies("Intranet")
>
>
If IsNothing(objCookie) = True Then
SetCookie("True")
End If
>
>
strMyEvents = objCookie.Values("MyEvents")
>
lblTest.Text = strMyEvents
>
>
End If
>
End Sub
>
>
>
>
>
Protected Sub SetCookie(ByVal strMyEvents As String)
>
Dim objCookie As HttpCookie
>
objCookie = New HttpCookie("Intranet")
objCookie.Expires = DateTime.MaxValue
>
objCookie.Values("MyEvents") = "True"
>
'Response.Redirect(objCookie.Values("MyEvents"))
>
>
End Sub
>

trouble with image

Hi guys,
I'm a beginner of asp.net:( When I click a
(System.Web.UI.WebControls.)Button on a page,of course,its' click event has
been assigned,the images on this page should be refreshed,right?These
images' imageurl are such as "getpic.aspx?id=xxx".But refresh doesn't
happen,why?
Much thanx.Presumably because the browser has cached the image that was at that
URL previously. If you want to load a different image for each screen
refresh then add a random number, or datestamp to the URL for your
image, that way the browser receives a different URL and will
redownload the image.
"Flinky Wisty Pomm" <Pathogenix@.gmail.com> wrote in message
news:1144079199.958679.87150@.v46g2000cwv.googlegroups.com...
> Presumably because the browser has cached the image that was at that
> URL previously. If you want to load a different image for each screen
> refresh then add a random number, or datestamp to the URL for your
> image, that way the browser receives a different URL and will
> redownload the image.
>
For a production environment, where the image may not change much, then I
would recommend removing the auto-generated number so that the cache
displays the image. Otherwise, the client may download more than it needs
too...<shrug>
Mythran
Thanx for your advice.My current problem: in the button click event,picture
stored in db is changed. "GetPic.aspx?id=xxx" is used to get pic from
db.What I want is after click,the image on this page should display the new
content(reload from db).But now db has updated successfully,the page is
still here,no change.
"Flinky Wisty Pomm" <Pathogenix@.gmail.com>
':1144079199.958679.87150@.v46g2000cwv.googlegroups.com...
> Presumably because the browser has cached the image that was at that
> URL previously. If you want to load a different image for each screen
> refresh then add a random number, or datestamp to the URL for your
> image, that way the browser receives a different URL and will
> redownload the image.
>
"removing the auto-generated number so that the cache displays the image"
Sorry but I have no idea how to remove,thanx.
"Mythran" <kip_potter@.hotmail.comREMOVETRAIL>
':eeIMsezVGHA.5044@.TK2MSFTNGP09.phx.gbl...
> "Flinky Wisty Pomm" <Pathogenix@.gmail.com> wrote in message
> news:1144079199.958679.87150@.v46g2000cwv.googlegroups.com...
> For a production environment, where the image may not change much, then I
> would recommend removing the auto-generated number so that the cache
> displays the image. Otherwise, the client may download more than it needs
> too...<shrug>
> Mythran
>
Much thanx,Flinky Wisty Pomm && Mythran:)
I got it,add a RequiredFieldValidator on the page and bind it to any
control,then nothing bother me:) But who can tell me why?puzzling
"tjer" <tj@.tj.edu.cn> д?:#jIoo1xVGHA.5288@.TK2MSFTNGP14.phx.gbl...
> Hi guys,
> I'm a beginner of asp.net:( When I click a
> (System.Web.UI.WebControls.)Button on a page,of course,its' click event
has
> been assigned,the images on this page should be refreshed,right?These
> images' imageurl are such as "getpic.aspx?id=xxx".But refresh doesn't
> happen,why?
> Much thanx.
>

trouble with image

Hi guys,

I'm a beginner of asp.net:( When I click a
(System.Web.UI.WebControls.)Button on a page,of course,its' click event has
been assigned,the images on this page should be refreshed,right?These
images' imageurl are such as "getpic.aspx?id=xxx".But refresh doesn't
happen,why?

Much thanx.Presumably because the browser has cached the image that was at that
URL previously. If you want to load a different image for each screen
refresh then add a random number, or datestamp to the URL for your
image, that way the browser receives a different URL and will
redownload the image.
"Flinky Wisty Pomm" <Pathogenix@.gmail.com> wrote in message
news:1144079199.958679.87150@.v46g2000cwv.googlegro ups.com...
> Presumably because the browser has cached the image that was at that
> URL previously. If you want to load a different image for each screen
> refresh then add a random number, or datestamp to the URL for your
> image, that way the browser receives a different URL and will
> redownload the image.

For a production environment, where the image may not change much, then I
would recommend removing the auto-generated number so that the cache
displays the image. Otherwise, the client may download more than it needs
too...<shrug
Mythran
Thanx for your advice.My current problem: in the button click event,picture
stored in db is changed. "GetPic.aspx?id=xxx" is used to get pic from
db.What I want is after click,the image on this page should display the new
content(reload from db).But now db has updated successfully,the page is
still here,no change.

"Flinky Wisty Pomm" <Pathogenix@.gmail.com>
??:1144079199.958679.87150@.v46g2000cwv.googleg roups.com...
> Presumably because the browser has cached the image that was at that
> URL previously. If you want to load a different image for each screen
> refresh then add a random number, or datestamp to the URL for your
> image, that way the browser receives a different URL and will
> redownload the image.
"removing the auto-generated number so that the cache displays the image"

Sorry but I have no idea how to remove,thanx.

"Mythran" <kip_potter@.hotmail.comREMOVETRAIL>
??:eeIMsezVGHA.5044@.TK2MSFTNGP09.phx.gbl...
> "Flinky Wisty Pomm" <Pathogenix@.gmail.com> wrote in message
> news:1144079199.958679.87150@.v46g2000cwv.googlegro ups.com...
> > Presumably because the browser has cached the image that was at that
> > URL previously. If you want to load a different image for each screen
> > refresh then add a random number, or datestamp to the URL for your
> > image, that way the browser receives a different URL and will
> > redownload the image.
> For a production environment, where the image may not change much, then I
> would recommend removing the auto-generated number so that the cache
> displays the image. Otherwise, the client may download more than it needs
> too...<shrug>
> Mythran
Much thanx,Flinky Wisty Pomm && Mythran:)

I got it,add a RequiredFieldValidator on the page and bind it to any
control,then nothing bother me:) But who can tell me why?puzzling

"tjer" <tj@.tj.edu.cn> д?:#jIoo1xVGHA.5288@.TK2MSFTNGP14.phx.gbl ...
> Hi guys,
> I'm a beginner of asp.net:( When I click a
> (System.Web.UI.WebControls.)Button on a page,of course,its' click event
has
> been assigned,the images on this page should be refreshed,right?These
> images' imageurl are such as "getpic.aspx?id=xxx".But refresh doesn't
> happen,why?
> Much thanx.