|
Trust me I would love to be able to implement in SQL Server, But unfortunately I am pretty tied into Access, although admitidly performance is not really an issue. Which leaves the authentication problem. How can you, in VB .Net Authenticate a client logging onto another machine?
Greg
|
|
|
|
|
You can't do it entirely in managed code yet. You'd have to map a drive using the WNetUseConnection API. See this MSDN Article[^] for VB6 code on how to do this (translates pretty good to VB.NET)
You might also want to look into using the Windows Scripting Host Network object to do it too.
RageInTheMachine9532
|
|
|
|
|
Hi,
Could someone help developing an application to monitor the web activity. I want to develop something like an internet spy software which monitors the web sites opened by my internet explorer.
Till now i have just been able to create a new instance of the internet explorer object and monitor the activity of the instance.
But any other instances creates other than that by the application are not monitored.
|
|
|
|
|
IE already has this built in, called History.
RageInTheMachine9532
|
|
|
|
|
|
HI!
Now what?
RageInTheMachine9532
|
|
|
|
|
The system.web.mail namespace allows for sending mail via SMTP right. But one thing I cant figure out. What if the SMTP server requires authentication? Can the SMTPMail class log you into the server and if so, how? or is there another way?
Greg
|
|
|
|
|
The System.Web.Mail class doesn't yet support logging into an SMTP server. You'd have to either search the web for a 3rd party variant or write a better SMTP class yourself.
RageInTheMachine9532
|
|
|
|
|
Hi all,
I'm attempting to make a custom Textbox that is not derrived from the WinForms Textbox, Richtextbox, or Textboxbase with VB.Net or C#.
I am at a loss of how to procede. Does anyone have any suggestions? Chris Losinger posted an article[^] explaining it in C++ (but I can't use the code), and the SharpDevelop editor is too complex for my needs.
Thanks,
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
|
You would either start a Windows Control Library or Windows Application project to start. This will give you the basic functionality of your control, like handling input, controlling the controls bounds, supplying your window handle, ..., but no painting code at all. See this[^] for a documentation start on MSDN.
RageInTheMachine9532
|
|
|
|
|
Thanks. It's not much, but it is a start.
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
|
Is there a way to add images into the listview columns kinda like how outlook can display a paperclip instead of text? I have seen that people say that you must tie into the API to do it, but no one provides examples. Does any one know how to do it and is willing to share how they did it?
Thanks,
- Nick
The network is down...let's go get bagels.
|
|
|
|
|
Hi,
I don't get what are you trying to do.
Adding images to the items or the columns header is very simple to do, no APIs need it.
Try something like this
Dim li As ListItem
ListView1.ColumnHeaders.Add 1, "col1"
ListView1.ColumnHeaders.Add 2, "col2", "col2"
'ImageList1 must have at least one image.
Set ListView1.SmallIcons = ImageList1
Set ListView1.ColumnHeaderIcons = ImageList1
Set li = ListView1.ListItems.Add(1, "item1", "", , 1)
li.ListSubItems.Add 1, "subItem1", "sutItem", 1
ListView1.ColumnHeaders(1).Icon = 1
I'll suggest you to read the documentation of the control on the MSDN, if after that you still have troubles getting it work as you want, let me know and I'll help you.
Fabian
|
|
|
|
|
It appears that is for VB and not VB.net... .NET does not seem to have ColumnHeaders. ANy thoughts on how to do it in .NET?
The network is down...let's go get bagels.
|
|
|
|
|
Sub : How to use Amazon Web Services..
Hi all...
Please let me know How to start with amazon web services..
I'm not finding any XML or REST Query format to send request to amazon..
I've purchased Seller account but How to use that to upload Items..I don't know...
Please help me getting start..
I hope some one definatly know about this
e-mail if attachment at sumit_kapoor1980@hotmail.com
Thanks...
Sumit Kapoor---
|
|
|
|
|
I'm trying to write some code (VB.NET) to dump the symbol information from DLL's or EXE's into XML. I've installed the debugging tools for windows, and tried using the dbghelp.dll API's but for some reason I can't reference dbghelp.dll in my project. So I tried reading the data into a pdb file using symhlp which works, but now I can't find a definition of the pdb file format anywhere so I can't convert to XML.... Does anyone have any experience doing this sort of thing, or code they could share?
Stuart
|
|
|
|
|
I want to use vbscript to fetch formula stored in database datatype is string which in turn will check the variables names in the formula field and get the values from another table and replace them this is then to be executed to get the results. It is payroll app.
The user enters in formula table "Basic + Hra" fetch this from table then check in values table Basic = 2500 and Hra = 1000. fetch this values then replace the variables and get the result
2500 + 1000 = 3500.
I am using VB 6.0 and developing payroll Application using Access. It is not a web based application
Prashant Nemane
|
|
|
|
|
Why Do you want to use script. Why not just use VB? You could use ADO in VB.
|
|
|
|
|
Dear Sir / Madam
Can you please tell me how to do it.
I am a beginer.
prashantnemane@rediffmail.com
Regards
Prashant Nemane
|
|
|
|
|
It Is Sir.
Here is a quick sample. Best to read up on ADO. it would be the same in script except set the Objects Set recordSet = CreateObject("ADODB.Recordset") and Set connectionObj = CreateObject("ADODB.Connection")
This assumes ODBC settings for DSN
Don't forget to reference ADODB in project
Public Const CURSOR_TYPE = 3<br />
Public Const LOCK_TYPE= 3<br />
<br />
Dim connectionString as string<br />
Dim sql as string<br />
Dim connectionObj As New ADODB.Connection()<br />
Dim recordSet As New ADODB.Recordset()<br />
<br />
connectionString = "dsn=DSN;uid=USER_ID;pwd=USER_PASSWORD;database=DATABASE_NAME<br />
sql = "SELECT name FROM sysobjects"<br />
<br />
connectionObj.Open(connectionString) <br />
<br />
'There are Many ways to access an retrieve data this is just one sample<br />
<br />
recordSet = connectionObj.Execute(sql)<br />
OR<br />
recordSet.Open(sql, connectionObj, CURSOR_TYPE, LOCK_TYPE)<br />
<br />
'Loop thru Record set (row) I believe this is only forward reading<br />
<br />
With recordSet<br />
Do Until .EOF<br />
<br />
'Get the COlumns in the Row and do something set to varilable, call other routine, etc..<br />
.Fields("name").Value ' this is the column name in the select statment (sql)<br />
OR <br />
.Fields.Item(0) ' also the column name, specify the column index number 0 to however many columns<br />
<br />
.MoveNext() ' go to next record<br />
Loop<br />
End With
Good Luck
|
|
|
|
|
how do u specifically name a column in the data grid?
right now the data i display in a data grid, comes with those column names, which are the names of various fields in my database.
i want to name them differently!
how do u do that?
|
|
|
|
|
You can specify the column name through HeaderText property like this.
Me.DataGrid1.TableStyles(0).GridColumnStyles(0).HeaderText = "MyColumn"
|
|
|
|
|
Or you could just format you sql statement differently and give each column an alias.
Select id as 'ID', name as 'User Name' .....
"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.
Support Bone
It's a weird Life
|
|
|
|
|
i am calling a SQL stored procedure from VB
i want to be able to call the stored procedure asynchronously...
i've tried different param values but the code gets called only synchronously...
below is the sample code that i am using...
Dim m_adoConn As new ADODB.Connection<br />
m_adoConn.Open "DSN=ConnectionNameHere"<br />
<br />
Dim com As ADODB.Command<br />
Set com = New ADODB.Command<br />
<br />
Dim rs As New ADODB.Recordset<br />
<br />
com.ActiveConnection = m_adoConn<br />
com.CommandType = adCmdStoredProc<br />
com.CommandText = "PopulateGroup"<br />
<br />
com.Parameters.Append com.CreateParameter("@sTableName", adWChar, adParamInput, 15, Null)<br />
com.Parameters("@sTableName").Value = "abcd"<br />
<br />
Set rs = com.Execute<br />
Debug.Print rs(0)
any help regarding this will greatly appreciated
Thanks
|
|
|
|
|
You're going to have to wrap the SQL stuff in some type of asynchronous method call. See this article[^] on CodeProject or a different method in this article[^] on MSDN.
EDIT:
Whoops! Your going to have to use VB.NET to do this. I can't find anything on doing it in VB6!
RageInTheMachine9532
|
|
|
|