|
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
|
|
|
|
|
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.
|
|
|
|
|
I am writing a app. and i have a problem. I want when I click a button then the app will run Microsoft Access and open a .mdb file which is available on hard disk?
Who help me???
Thanks
tramdtt
|
|
|
|
|
Download the Primary InterOp Assemblies from Microsoft. There are examples there on how to instantiate any office application and then programatically invoke its methods and functions. Opening a Access file should then be a snap.
|
|
|
|
|
Thank u very much. I'll try
Good luck
tramdtt
|
|
|
|
|
vb6 ?
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nshowCmd As Long) As Long
Private Const SW_SHOWNORMAL = 1
Private Sub Command1_Click()
ShellExecute hwnd, "open", "C:\Folder\FileName.mdb", vbNull, vbNull, SW_SHOWNORMAL
End Sub
|
|
|
|
|
In my app my main form has 2 panels seperated by a splitter control - on the control on the right the user can add windows forms (don't ask) and then move them about using the title bar or resize them as you would a normal resizable window - the problem is if the user resizes the panel using the splitter the app kind of loses track where the windows are on the panel.
Is there a way to tell the app where the windows are once the resize has been done?
|
|
|
|
|
PaleyX wrote:
the problem is if the user resizes the panel using the splitter the app kind of loses track where the windows are on the panel.
What do you mean by "loses track of where the windows are?"
What happens to the windows?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Sorry, I realise I didn't explain that very well. Essentially the user can move the windows forms around on the panel and can resize them as per any resizable windows form but after the panel has been resized using the splitter it seems that windows thinks the window isn't where it is currently displayed but where it was before the panel was resized. Does that make sense?
Rugby League: The Greatest Game Of All.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
