Use The DHCP Server Management API To Query Scopes And Reservations On A DHCP Server?

Sep 28, 2009

I'm looking to use the DHCP Server Management API to query scopes and reservations on a DHCP server.

ADVERTISEMENT

Contacting The DHCP Server?

Oct 13, 2009

Hello,does anybody know if it at all possible to contact the DHCP server from a VB.NET project with the aim of passing a computer name and it returning the MAC address (and last known IP address). The purpose is that the machine may be switched off which is why we need to go to DHCP Server.Basically need to know the Libraries to imports and get started.

View 4 Replies View Related

TCP Client/Sever With DHCP?

Feb 8, 2010

I have a simple TCP Client/Server application that ties two pcs on a lan together. This has worked great for many job sites but the most recent has an IT manager that will not allow me to set a static ip address on the server pc.Basically, I was wondering if there was a nifty way to have the client find the server.

View 25 Replies View Related

Communications :: IP Address Static Or DHCP?

Apr 12, 2010

I am trying to write a quick utility that will find out if a Windows XP computer is set to Static or DHCP and write a log file c:computername_static.log or c:computername_dhcp.log.

View 2 Replies View Related

VS 2010 Get DNS IP / DHCP IP And Defaul Gateway IP

Jun 10, 2011

I am developing a windows application for my guys on helpdesk to use with our clients. It is going to be installed on the clients' pc's. One of it's purposes is to display all IP info of a computer. Such as the client's IP address, DNS IP address, DHCP IP address, and Default Gateway IP address, but I can only get it to give me the IP address of the host and no addresses of the DNS, DHCP, or Default Gateway. I know that I could run an ipconfig /all and pull the results into the application, but I would like to have it laid out more simply for it to be easier to read for the clients in case we are walking them through some troubleshooting over the phone and we need their IP information. I do not require and am not requesting any source code.

View 6 Replies View Related

VS 2008 : Use The DHCP API To Retrieve A Computer's MAC Address When Given The IP Address?

Nov 27, 2009

I'm trying to use the DHCP API (using the references on pinvoke.net) to retrieve a computer's MAC address when given the IP address but I can't get the code to work. I've run all the C# code on pinvoke.net through the C#-to-VB converter but I'm stuck now.

Here's what I have so far. The value of res is always 5 (should be 0). Thing is, I can't find any documentation on what the return codes mean

vb
Private Sub GetMACDim client As String = "1.1.1.1"        Dim server As String = "0.0.0.0"        Dim si As New NativeMethods.DHCP_SEARCH_INFO        si.SearchType = NativeMethods.DHCP_SEARCH_INFO_TYPE.DhcpClientIpAddress        si.ClientIpAddress = Convert.ToUInt32(StringIPAddressToUint32(client))         Dim res As UInteger        Dim oInfo As IntPtr    

[code]....

View 2 Replies View Related

Developing With SMO (SQL Server Management Objects)?

Oct 16, 2009

Below I have the create script for a table.  It works great but for some reason it doesn't include the Keys, Constrains, Triggers or Indexes.  I am having little luck finding documentation on how to do this.  Most of the example I can find is in C# as well.

Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common
Imports System.Collections.Specialized

[code]....

View 2 Replies View Related

Connect .net 2010 To Sql Server Management Exp 2005?

Jan 22, 2012

heres my connection module
Imports System
Imports System.Data
Imports System.Data.SqlClient

[Code]...

View 11 Replies View Related

Install SQL SQL Server Management Studio Express Silently?

Sep 28, 2009

where that i find the commands for make an silent install of SQL Server Management Studio Express.The same thing i did with sql express 2005:

infoSQLExpress.FileName = DirectoryGet + "appsSQLEX05.EXE"
infoSQLExpress.Arguments = "/qb INSTANCENAME=" + txtInstanzname.Text _
+ " ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity" _[code]......

View 1 Replies View Related

Irc Server - Computers - Able To Control Them Remotely Without Using External Dekstop Management ?

Jan 6, 2009

At my house we got 6 computers and 5 laptops. Not I want to be able to control them remotely without using external dekstop management or something else. So i can control when my kids can use the computer or not

So I came up with the idea of creating an irc server that listens to commands that I type from my main computer. The commands are no problem for me to program but the irc server itself looks pretty hard. I've been looking on google but cant find a good source to learn it. some other ideas than using irc protocol?

View 1 Replies View Related

Data From Excel 2007 To Microsoft SQL Server Management Studio Express?

Jun 22, 2009

How do I transfer data from Excel 2007 into Microsoft SQL Server Management Studio Express as shown below? I try copy and list of data in excel as shown in the screenshot.. But when I paste in Microsoft SQL Server Management Studio Express.. Only the first result is past inside..

View 2 Replies View Related

Deployed And Installed Application / Want To Attach Database Within SQL Server Management Studio

Mar 9, 2009

I've developed an application in VB2008 express and have installed it to another PC. The installation has put the mdf file in c:documents and settingsuserappsdata.I want to attach this with SQL Server Management studio but when I try to browse to the file in order to attach it, I find I can't browse further then C:documents and settingsuser.

View 3 Replies View Related

Get The Stored Procedure Have Created At SQL Server Management Studio Using Code Behind The Files?

Aug 3, 2011

How can I get the output data of sql procedure from SQL Server to my asp.net[vb.net] page dropdown list?<asp:DropDownList ID="DdLocation"></asp:DropDownList>

View 1 Replies View Related

Updating A Data User 2008 And Sql Server Management Studio Express

Apr 19, 2011

I'm trying to update a data user using vb.net2008 and sql server management studio express for my backend. the error says "must declare the scalar variable "@username"

Here's the code .

Private Sub btnupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles btnupdate.Click    
Dim connstring = New SqlClient.SqlConnection("Data Source=MISD-

[CODE]...

View 1 Replies View Related

Data Management - Changing Current Database System, MS Access 2007 Front End And MS SQL Server 2005 Backend

May 8, 2012

We are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.

View 12 Replies View Related

Asp.net - Sql Server Query DropDownList Selected Value

Apr 30, 2012

I have a DropDownList that pulls values from a table in sql server. I want the dropdownlist to populate the list of values based on a selection by the user but also display the contents of the rest of my table in case they need to change something. For ex:

ddl1 has values of: 1, 2, 3, 4, 5 user selects 5, so the value displayed in ddl2 is five, but if you exand the ddl2 you will also see the values of one, two, three, four...

This is the code in my load event...

If Not IsPostBack Then
result = dal.dbConnect(DAL.dbType.SqlServer, ConfigurationManager.AppSetting("SQLServerConnection"))

[Code]....

View 3 Replies View Related

Display Query Results From SQL Server In VB?

Apr 8, 2012

I am trying to display query results from SQL server in VB. I wrote following code, but not getting how to "Just display the results";

[Code]...

View 2 Replies View Related

Sql Server - .Net Incorrect Syntax With SQL Query?

Jan 10, 2012

Command = New OleDbCommand("SELECT dbo.tbl_staff.staff_id, dbo.tbl_staff.username, dbo.tbl_staff.password, dbo.tbl_useraccount.position_id " & _
"FROM dbo.tbl_position INNER JOIN " & _

[code]....

It says incorrect syntax.

View 1 Replies View Related

Sql Server - Pagenation On A Blog SQL Query?

Oct 13, 2011

I have a blog (non wordpress or anything) written in vb.net. At the moment I pull my data back just by bringing in the last 10 results: SELECT TOP (@bAmount) bCategory, bID, bImageURL, bInactive, bLargeImage, bPost, bPostDate, bPostTitle, bPoster, bStyle FROM Blog ORDER BY bID DESC

I'm just going to have back and forward buttons to go through the posts, but how do I do the SQL for say post 10-20 last posts rather than the IDs between the posts. (The IDs are incrimental, but can jump significantly).

So basically when I click back it gives me 10 posts that are 10 older than the first page results?

View 4 Replies View Related

Sql Server - Sql Query And Double Var Values?

Aug 18, 2011

Im having an issue with a certain query,Dim nwLat As Double Dim Ssql As String

nwLat = nwLatHidden.Value
Ssql = " select * from customer where latitude < " & nwLat
TFRcount.SelectCommand = Ssql
TFRcount.SelectParameters.Clear()
TFRcount.DataBind()

All it does is refresh the page and does nothing; it should populate a chart. However when I replace nwLat with a value (eg where latitude = 56) it works perfectly and populates the chart. Any ideas what's wrong with nwLat?

EDIT: I switched nwLat to long and it works; however it only takes the number up to the decimal and ignores the rest. Any way to fix? (eg as double 56.764746 and long 56)

View 2 Replies View Related

Sql Server - Store / Query Data In .NET?

Nov 23, 2011

At the moment I am using Access & an OleDb connection to store data. I went down this route originally because I though that this was the best way for applications that I am distributing to my clients.

I would prefer to use something like SQL Server but is this a good idea for software I am distributing? Does the average Joe's PC have SQL Server pre-installed? If not, I suppose I can provide them with a link to download it for free?

Is there any better alternatives to Access / SQL Server?

View 2 Replies View Related

Sql Server Query To Group Records?

May 9, 2011

i would like to select from the following table:

PostTable

feed dateinserted count
box1 2011-05-28 11:00 1000[code].....

the total number of records for the previous day where the feed is, 1, 3 and 5 i.e.the feeds I need to retrieve totals for will just be selected based on what I need for instance it could be box4 and box 5...not specifically odd and even...I hope this makes it more clearer..what I have for all records:

select sum(count) as [total] from PostTable where Cast(dateinserted as DATE) =
CAST(getdate()-1 as DATE)

View 3 Replies View Related

VS 2005 WMI Query - SQL Server Startup

Jan 5, 2011

I'm writing a program that will be able to start a window service (SQL Server) on demand. Some of our servers have both SQL 2000 and SQL 2005 installed. I'd like to run a WMI query on the server (either local or remote) to determine how many instances of SQL are installed, and then start the latest version of SQL server. Install paths to SQL instances / configs can be different due to SAN configuration, so I need to use a WMI query to get the services.

I was using the following query- "SELECT * FROM Win32_Service WHERE Name LIKE '%MSSQL$%' OR Caption = 'MSSQLSERVER' OR Name = 'SQLSERVERAGENT' OR Name LIKE '%SQLAgent$%'" This returns a bunch of SQL services, so I decided to cut it down- "SELECT * FROM Win32_Service WHERE Name LIKE '%MSSQLSERVER%' OR Caption = 'MSSQLSERVER'" But that query still returns other services (i.e. FullText, Active Directory Helper, etc.) that I don't want. Is it possible to create a WMI query to only look for MSSQLSERVER and SQL Server Agent services? Am I missing something?

View 4 Replies View Related

Asp.net - Use VB To Query Remote Server Event Logs?

Aug 27, 2009

I am working on creating a web app that will query event logs on internal servers for events using a specific ID. Since most of the servers are running Windows Server 2003, I cannot use the preferred System.Diagnostics.Eventing.Reader method that I was hoping to use.

I've seen the mention of using WMI, but would like to avoid this if possible. I have dabbled with the System.Diagnostics class but cannot seem to get it working when running on a server. It is able, when testing locally, to query my event log, but displays nothing when put on the final server. There is no error that is displayed after the program is ran.

View 1 Replies View Related

Query A Game Server And Parse The Results?

Apr 10, 2009

Has anyone ever done this? Is there a tutorial somewhere?

View 1 Replies View Related

Query SQL Server Table Results Into A List?

Apr 13, 2012

I am trying to create a CLR SQL Stored procedure that uses a query and adds the results to a list in VB.NET. Through debugging I determined that my add statement for the reader into the List is somehow converting my data types and throwing an error when I attempt to execute the compiled Stored Procedure.The columns I am querying are Integers

Code:
Imports System
Imports System.Data

[code].....

View 3 Replies View Related

Row In Datagridview Not Come All When Query From Database (sql Server 2008)?

Dec 21, 2011

row in datagridview not come all when query from database (sql server 2008)?

View 4 Replies View Related

Run Query On In - Memory DataTable & Server Data

Jun 14, 2009

I wrote a procedure that builds a DataTable in memory using data stored on our DB2 database. The function builds a Multi-Level Bill of Materials (BoM), meaning that the data cannot simply be queried. The function works great and returns a nicely arranged DataTable object. However, I then need to query the in-memory DataTable against other tables on our server. What would be the best way to approach this problem? Should I make a DataTableAdapter for the Server tables and then build a DataView? I don't have too much experience yet with Data objects. (By the way, I looked into LINQ to DB2 and even installed IBM's addin's, but our server doesn't seem to support it at this time.)

View 6 Replies View Related

SQL Query Works In SQL Server But Not When Called From Checkbox

Nov 21, 2010

I've got a datagrid with checkboxes which calls a routine called checkbox_CheckedChanged. So far, so good. I've managed to get it to work out the value of another column in the dataview, which allows me to ascertain the id of the row I'm dealing with. I'm trying to get it to change the value of the column which defines the initial value of the checkboxes, but the SQL I've written doesn't work when called by vb.net - it does work when entered manually into SQL server, however. Here's my code behind:

[Code]...

View 1 Replies View Related

C# :: Aggregate Or Join Strings In Linq To Sql Query (SQL Server)?

Aug 6, 2010

Given a table like

ID | Name | City
1 | X | Y
2 | Z | Y

[code].....

View 2 Replies View Related

Class Variables - Holding Data From SQL Server Query

Oct 1, 2009

I am creating an ASP.Net page with VB.Net codebehind. I am using a class variable to hold data (named ods see below) from a SQL Server query so I do not have to keep going back out to the server. The class variable gets loaded ok and I populate a grid data with this dataset. However when I need to go back in and reference the dataset again, I get an error and I come to find out my dataset no longer holds the data.

Here is my declaration in my code behind:
Partial Public
Class LotTrackingMain
Inherits System.Web.UI.Page
Private con
As SqlConnection =
Nothing
Private ods
As
New DataSet

View 3 Replies View Related

How To Create Sql Query With Monthname In Vb 2010 Using SQL Server 2008 R2

May 5, 2012

i am using vb 2010 and sql server 2008 r2 how to Create sql query with monthname and Year? Like "May 2012"

i have a form with Two ComboBoxes
ComboBox1 = 2012
ComboBox2 = "May"
How To Make Query  from Invoice Table
have field in Invoice Table "InvoiceDate"

View 1 Replies View Related

Multi - Table Join Query In ASP.NET To SQL Server Via LINQ?

Jan 29, 2012

I'm working on an ASP.NET 4.0 site, which I inherited ownership of. It has a number of existing LINQ datasources pointing to individual tables. For example, to the Patient Encounter Summary table in SQL Server. The problem is in displaying the data there. It's a normalized database, so that table contains (for example) the provider ID, rather than the provider name.

It's simple enough to join the Patient Counter Summary to the Providers table (in SQL)... but how does one do that in ASP.NET? I'm not sure of the correct nomenclature, but the 'mid layer' is VB.

[Code]...

View 3 Replies View Related

Sql Server - ExecuteScalar And SqlDataAdapter.Fill Behave Different For Same Query?

Jul 8, 2011

I have a big stored procedure that I run. At the end its supposed to select a singe value to say if it succeeded or not, so I run the query as

Dim Command As New SqlCommand(SqlString, Conn)
Return Command.ExecuteScalar()

Which works. However there is an error in my stored procedure. I know its causing an error because the logic in the stored procedure rolls back the transactions, and after the Execute Scalar call, my transaction count is down to 0 and the my data hasn't changed. However no SQL exception was generated.

The strange part is, I changed the code to grab all the result sets from the SP to see if I could get more information. So I called the same SP like this,

Dim DAObj As SqlDataAdapter = New SqlDataAdapter
Dim CommandObj As SqlCommand = New SqlCommand(SQLString, Conn)
DAObj.SelectCommand = CommandObj
Dim DS As New DataSet()
DAObj.Fill(DS)

When I run this, with the exact same sql as before, executing the exact same stored procedure, this time I get an SQL exception because one of my nested SP calls was missing required parameters. So what could cause this? Why would running it one way produce an error and the other way have the error but not report it? Is the difference on purpose, or some kind of obscure bug in ADO.Net?

View 2 Replies View Related

Updating Game Server Query Protocols - VB 2008

Apr 18, 2009

I have a working game server browser project in VB.NET 2008 and I'm trying to fix the CS 1.6 and CS-Source query protocols. Where can I go to learn how to query a game server? The code worked in 2004 and now I want to update it [Code]

View 2 Replies View Related

Efficiently Obtain A Two Dimensional Array Result From A SQL Server Query?

Jun 11, 2012

I'm attempting to make a generic query executer function. I want to be able to send it a query string and have it return a two-dimensional array containing the results. Below is my code for how to do it with a (9,x) array. How can I do it with an (y,x) sized array? Also, I feel like there must be a more efficient way to do this..

[Code]...

View 3 Replies View Related

Format XML Data In Values Using Insert Query In SQL Server 2008?

Feb 16, 2012

INSERT INTO [ET_SolutionText]
([SolnTextKey]
,[SolnTextValue]
,[SolnTextTitle])

[code]....

In Above Query, SolnTextValue is XML field. How i can format XML data in Values using insert query in SQL server 2008?

View 1 Replies View Related

Microsoft Indexing Server Query To Search The Document Not Working?

Jul 27, 2011

I want the Indexing server Query to Search any type of document by document name.Let assume i have ..

test.ppt
test.pdf
test.doc and so on.

If I enter the test name in my search text box the , I want the search result with these file. I am using the vb.net with the help of MicroSoft Indexing Serice. I need the query of MicroSoft Indexing Serice for search any type of document by document name or title.

Public Function GetSearchResultFromIndexServer(ByVal strSearchString As String, ByVal sPath As String, ByVal sLookIn As String, ByVal sSortBy As String, _

[code]....

View 1 Replies View Related

Query Designed For MySQL Translated To Work For SQL Server 2005?

Apr 10, 2010

I've spent a whole day on this already without figuring it out. I'm hoping somebody can help me translate the following MySQL query to work for SQL Server 2005:

SELECT MAX ( messages.date ) AS maxdate,
topics.id AS topicid, topics.*, users.*
FROM messages, topics, users WHERE messages.topic_id
= topics.id AND topics.user_id = users.id AND
topics.forum_id = " . $forumid . " GROUP BY
messages.topic_id ORDER BY maxdate DESC

$forumid is a QueryString value defined in the following VB.NET code-behind code:

forumName.Text = "<a href='ViewForum.aspx?forumid=" & row.id & "'>" & row.name & "</a>"

View 2 Replies View Related

Send Query Via Soap To Secure Server And Import Response

Jun 17, 2010

This is my first time using SOAP with anything. I have an interesting situation, I have to send query's via soap to a secure server and get a response back and then import the response into a database. I have the connection to the secure server figured out and importing the returned xml figured out. I followed examples however I get nothing back in the service windows from the remote web site.

Here is my vb.net code with the soap request inside:
Imports System.Net
Imports System.Security.Cryptography.X509Certificates
Imports System.IO
Imports System
Imports System.Text
Imports System.Data
[Code] .....

View 10 Replies View Related

Sql Server - Convert A Date And Time Into A MS SQL Select Query Using SelectParameters

May 29, 2009

I have this situation where I have a SqlDatasource control and the select query is like:

SELECT col1, col2 FROM table1 WHERE colDate = @date

The source of @date is a label with the text: 2009-05-29 12:06:00 I get the following error when I run the query:

Conversion failed when converting date and/or time from character string

I tried using convert(datetime, @date), as well as different date/time formatting of the label itself. Everytime I get the error.

However, when I run the query in the management studio like:

SELECT col1, col2 FROM table1 WHERE colDate = '2009-05-29 12:06:00'

I found out that the @date is parsed as 05-29-2009 01:30:00 TT I don't know where the TT is coming from? And I'm sure SQL Server wouldn't be able to handle it?

View 3 Replies View Related

After Running Insert Or Update Query, Need The Last Inserted Record And Compare In .net Sql Server?

Mar 11, 2010

i have 2 queries in vb.net with an if clause -

if x=0 then
insert into table1
else
update table1

both queries have 5 fields. now what i want to do is after this insert or update takes place, i need to look at this inserted/updated record and compare it with another table (table2). Especially for update, i have 5 fields in both tables. if any of the 5 fields dont match with table2, then i insert a new record in table 2 which is the updated record in table 1.

View 1 Replies View Related

DB/Reporting :: Test A Number Of Stored Procedures Through SQL Server Query Analyzer?

Mar 17, 2008

I am trying to test a number of stored procedures through SQL Server Query Analyzer. But am stuck when I try to test stored procedures that contain Output parameters.

Code:
DECLARE @Counterbigint
DECLARE @GUIDuniqueidentifier
exec usp_tbl_User_Add @Counter, @GUID, 'UserName', 'First Name','Surname',

[Code]....

When I put the Select statement though in the 'usp_tbl_User_Add' stored procedure in works fine and gives me the correct values.

View 2 Replies View Related

Insert Into Query(sqlserver) (visual Studio 2010 - Sql Server 2008)

Jul 8, 2011

I am working in a project where i have to add employees in a company. I have a form with text fields(for example name,surname,age,...). What i want is to insert this txt values into a database. My project is connected with an sql database. How can i add the values into a data table on button click("submit")?

View 9 Replies View Related

Micro Soft Indexing Server Query To Search The Document Not Working?

Jul 26, 2011

I want the Indexing server Query to Search any type of document by document name.

Let assume i have ..
test.ppt
test.pdf
test.doc and so on.

If I enter the test name in my search text box the , I want the search result with these file. I am using the vb.net with the help of MicroSoft Indexing Serice. I need the query of MicroSoft Indexing Serice for search any type of document by document name or title.

[Code]...

View 2 Replies View Related

ADVERTISEMENT