Re: adding days to current day being displayed - Visual Basic Discussion Boards

Re: client/server read and write

fo0lish8-Jun-04 5:45

fo0lish

8-Jun-04 5:45

sorry to keep buging you, but now im thinking WebService.
Would you think this is the way to go?

Re: client/server read and write

Dave Kreskowiak8-Jun-04 6:47

Dave Kreskowiak

8-Jun-04 6:47

From the description of the problem that you gave, it sure is. Very easy to implement too.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: client/server read and write

fo0lish9-Jun-04 14:59

fo0lish

9-Jun-04 14:59

would you be so kind as to point me to a good example on this project

thank you

Re: client/server read and write

Dave Kreskowiak9-Jun-04 15:30

Dave Kreskowiak

9-Jun-04 15:30

A simple Google on "WebService VB.NET Tutorial" turns up a bunch of them...
http://abstractvb.com/code.asp?F=1&P=2&A=1004[^]
http://www.freevbcode.com/ShowCode.Asp?ID=4204[^]

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

adding days to current day being displayed

devgeez8-Jun-04 5:08

devgeez

8-Jun-04 5:08

I have a datagrid where you can click and view form submittions. I am displaying the title of the form and the date the form was submitted. On the original form I had a radio button list that requests the time of the evaluation ie:
<asp:radiobuttonlist id="Time" Runat="server" RepeatDirection="Vertical">
<asp:ListItem Value="Standard (within 90 days)"></asp:ListItem>
<asp:ListItem Value="Escalated (within 60 days)"></asp:ListItem>
<asp:ListItem Value="Urgent (within 30 days)"></asp:ListItem>
</asp:radiobuttonlist>
I have now been asked to display my result page with the date plus what ever the user choose on the radio button.
So something like this 5/01/2004 +30 days = 6/11/2004 (as the day I should display.
or 5/1/2004 +60 days = 7/1/2004 and so on.
Problem is I dont know how to accomplish this.
Can someone guide me...
here is my datagrid
<asp:DataGrid ID="dg" Runat="server" Visible="False" Cellpadding="4" Autogeneratecolumns="false" AllowSorting="true" OnSortCommand="dg_SortCommand">
<columns>
<asp:boundcolumn headertext="DATE SUBMITTED" Datafield="datesubmit" DataFormatString="{0 Big Grin | :-D

}" SortExpression="datesubmit" />
</columns>
</asp:DataGrid>

Re: adding days to current day being displayed

Dave Kreskowiak8-Jun-04 5:38

Dave Kreskowiak

8-Jun-04 5:38

There are several ways of doing this, but the easiest is haveing your database server return the dataset with the number of days already added. You'll have to supply the number of days to add to a function in your data access layer and have that function return the dataset from the database. The function will call the database stored procedure with the number of days to add. The stored procedure will return the records for the function to return in a dataset.

The SQL statement might look something like this:

SELECT DATEADD(day, @DaysToAdd, submitteddate) FROM tablename

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: adding days to current day being displayed

devgeez8-Jun-04 8:16

devgeez

8-Jun-04 8:16

thanks for the feedback. do you have a sample i can go by.

Re: adding days to current day being displayed

Dave Kreskowiak8-Jun-04 8:43

Dave Kreskowiak

8-Jun-04 8:43

Don't tell me you're doing something like this:

Dim sqlComm As New SqlCommand
sqlComm.CommandText = "SELECT god knows what FROM god knows where"
sqlComm.CommandType = CommandType.Text

I would HIGHLY SUGGEST, no, DEMAND (yeah, that's more like it!) that you stop this practice now and rewrite your code to use stored procedures and parameterized queries. I, obviously, can't stress this enough...

Here's[^] a sample of what I'm talking about...and this[^], and whatever you do, don't skip this[^] chapter from Patterns & Practices. I know it's kind of long, but it is THE most important thing your going to read about ADO.NET data access and how to do it properly!

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: adding days to current day being displayed

devgeez9-Jun-04 4:45

devgeez

9-Jun-04 4:45

thanks for the feedback...ill make sure and do that.
since all i need to wrap up the project I am hoping that you can share some advice.
This is a display page that already has the values submitted. I am quering the database and bringing the values already submitted on the original form to be display. Where I need the dates +30, 60 or 90 are on my admin page. On this page there are 2 dropdownlist that you can select a topic and the status and then displays the datagrid based on the selection. Lets say I made my selection on the results table it displays rows with the following a row that has the date the form was submitted / name of the form /the department where the form originated from and a link to actually view the form.
ie: <asp:DataGrid ID="dg" Runat="server" Visible="False" Cellpadding="4" Autogeneratecolumns="false" allowSorting="true" OnSortCommand="dg_SortCommand">
<columns>
<asp:boundcolumn headertext="REQUESTED COMPLITED DATE" Datafield="datesubmit" DataFormatString="{0 Big Grin | :-D

}" SortExpression="datesubmit" />
<asp:BoundColumn HeaderText="PRODUCT NAME" DataField="txtProductName" SortExpression="txtproductname" />
<asp:BoundColumn HeaderText="DEPARTMENT" DataField="deptname" SortExpression="deptname" />
<asp:HyperLinkColumn HeaderText="VIEW DETAILS" DataNavigateUrlField="reqid" DataNavigateUrlFormatString="CscReqDetails.aspx?reqid={0}"
Text="View Details" HeaderStyle-CssClass="RedLink"></asp:HyperLinkColumn>
</columns>
</asp:DataGrid>
I need to change the datesubmit based on the selection from the time RadioButtonList id="Time" selection the user makes when he first submits the original form. lets day form was submitted on June 15th, 2004 and they selected that the form needs to be evaluated within 30 days then i need to display on this datagrid July 15th, 2004 as the date. This is what I am trying to accomplish.
thanks for the advice.
I have created the follwing sub function but I am not seing the dates + the time requested for the evaluation.
Sub GetDate()
Dim datesubmit As Date = datesubmit 'System.DateTime.Now.Date
Dim strHold As Date
Dim rdlTime As String
Select Case rdlTime
Case "Standard (within 90 days)"
datesubmit = datesubmit.AddMonths(3)
Case "Escalated (within 60 days)"
datesubmit = datesubmit.AddMonths(2)
Case "Urgent (within 30 days)"
datesubmit = datesubmit.AddMonths(1)
End Select
Response.Write("After : " + datesubmit.ToString())
End Sub

any thoughts?
I am calling this function on the pageload.

client/server read and write

fo0lish8-Jun-04 4:52

fo0lish

8-Jun-04 4:52

ok i have searched the web on this and cant find it anywhere,
basicly what i wana do is take info from a textbox on the client side send it to the server, have the server check a access database and return a true of false to the client. My tcpserver is a Console App and my tcpclient is a windows App, also does anyone know of a good book on vb.net, Im ok with vb6 but new to vb.net
thanks
j

Re: client/server read and write

Dave Kreskowiak8-Jun-04 5:12

Dave Kreskowiak

8-Jun-04 5:12

What you describe fits the profile of a WebService perfectly. But if you must use a different remoting option, check out these[^] examples. You might also want to check out a sample that was installed with Visual Studio .NET at <SDK>\v1.1\Samples\Technologies\Remoting\Basic\RemotingHello. This will do about the same thing that you described.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: client/server read and write

fo0lish8-Jun-04 5:20

fo0lish

8-Jun-04 5:20

I think its time to buy a good book about vb.net so i can get the most out of the .net language.....any ideas?

Re: client/server read and write

Dave Kreskowiak8-Jun-04 5:30

Dave Kreskowiak

8-Jun-04 5:30

'Good' is a matter of preference and past experience.
You might want to check out "Professional VB .NET, Second Edition", or "Advanced .NET Remoting in VB .NET". You can find both at Amazon[^].

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Set Current Directory

Brad Fackrell8-Jun-04 3:48

Brad Fackrell

8-Jun-04 3:48

Hi All.

Based on a suggestion that Dave made earlier, I’m trying to ‘set my current directory’ to the value of a variable.

homeDir is a string that holds the current path i.e. c:\current\path

I can’t figure out how to use Directory.SetCurrentDirectoy with this variable. Can anybody help?

Thanks
Brad

Re: Set Current Directory

Dave Kreskowiak8-Jun-04 3:54

Dave Kreskowiak

8-Jun-04 3:54

You might want to try posting the code that you're using too. It help to diagnose other potential problems with what your doing. Anyway, at the top of your code, make sure that you have:

Imports System.IO

Then, it's just a simple matter of:

.
.
Directory.SetCurrentDirectory(homeDir)
.
.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Set Current Directory

Brad Fackrell8-Jun-04 4:50

Brad Fackrell

8-Jun-04 4:50

That did the trick!

I forgot to add: Imports System.IO

Thank you very much Smile | :)

Brad

sql data adapter

ymohd_2228-Jun-04 0:25

ymohd_222

8-Jun-04 0:25

When i write this code:
Dim pubsadapter As sqldataadapter = New sqldataadapter("select*from authors", pubssqlconn)

then build it

the result: sqldataadapter is not defined

Go forward and never Stop....

Re: sql data adapter

Dave Kreskowiak8-Jun-04 2:51

Dave Kreskowiak

8-Jun-04 2:51

Did you put this at the top of your code file? You have to declare the namespaces you want to import so these classes are defined.

Imports System.Data
Imports System.Data.SqlClient

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

snmp

beowulfagate7-Jun-04 22:02

beowulfagate

7-Jun-04 22:02

Anybody here tried snmp in vb.net? Could use some help on how to get started. Any ideas?

Hardship Breeds Character.

Re: snmp

Dave Kreskowiak8-Jun-04 2:46

Dave Kreskowiak

8-Jun-04 2:46

You didn't say what you wanted to do with SNMP, so the documentation starts here[^]. You'll, again, have to P/Invoke everything since there is no native support for these functions in the .NET BCL.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: snmp

beowulfagate8-Jun-04 14:51

beowulfagate

8-Jun-04 14:51

Basically, I wanted to perform the mac-to-ip conversion there. If I could retrieve the computer's IP address, then query for the NIC's MAC address, I am there. Is that right?

Re: snmp

Dave Kreskowiak8-Jun-04 15:14

Dave Kreskowiak

8-Jun-04 15:14

Nope. If there is no SNMP service running on the target computer, you won't get back anything. The NIC's driver must support such a function and I haven't seen one yet that'll do what your describing. Just the normal ARP stuff is supported...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: snmp

beowulfagate8-Jun-04 18:50

beowulfagate

8-Jun-04 18:50

I've come across an application that enumerates the mac addresses of computer connected to a certain switch and it required me to enter the snmp community string. Any idea how to implement this kind of feature?

Re: snmp

Dave Kreskowiak8-Jun-04 23:58

Dave Kreskowiak

8-Jun-04 23:58

That's because the switch has SNMP support built into it. The app just asked the switch and it reported everything through its normal administration interface, SNMP.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Crystal Report

7-Jun-04 19:34

For a Graph Chart Report
There is option called chart Export,
In that 2nd option called DATA
In that after selecting show value

There is Check box its not allowing to select Don't summarize values

Please help me how to select Don't summarize values check box.

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