|
|
sorry to keep buging you, but now im thinking WebService.
Would you think this is the way to go?
|
|
|
|
|
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
|
|
|
|
|
would you be so kind as to point me to a good example on this project
thank you
|
|
|
|
|
|
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 }" SortExpression="datesubmit" />
</columns>
</asp:DataGrid>
|
|
|
|
|
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
|
|
|
|
|
thanks for the feedback. do you have a sample i can go by.
|
|
|
|
|
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
|
|
|
|
|
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 }" 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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
'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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
That did the trick!
I forgot to add: Imports System.IO
Thank you very much
Brad
|
|
|
|
|
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....
|
|
|
|
|
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
|
|
|
|
|
Anybody here tried snmp in vb.net? Could use some help on how to get started. Any ideas?
Hardship Breeds Character.
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|