|
I'm using the following code to get a list of databases on a Microsoft SQL server. In this case you supply it a user name and password, but is there a way to tell it to use windows authentication instead?
Dim sqlserverlist As SQLInfoEnumerator = New SQLInfoEnumerator
sqlserverlist.SQLServer = Me.ComboBox1.Text.ToString.Trim
sqlserverlist.Username = Me.TextBox1.Text.Trim
sqlserverlist.Password = Me.TextBox2.Text.Trim
Me.ComboBox2.Items.AddRange(sqlserverlist.EnumerateSQLServersDatabases())
|
|
|
|
|
use microsoft sqlserver connection info dll files
private static Server srvSql;
private static ServerConnection srvConn;
void ReadDatabase(string _ServerName)
{
try
{
srvConn = new ServerConnection(_ServerName);
srvConn.LoginSecure = true;
srvSql = new Server(srvConn);
foreach (Database MyServer in srvSql.Databases)
{
cmboDB.Items.Add(MyServer.Name);
}
}
catch (Exception DbExp)
{
MessageBox.Show("Error in Connection !!!!", "Database ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
Check this section
// Log in using SQL authentication instead of Windows authentication
//srvConn.LoginSecure = false;
// Give the login username
//srvConn.Login = txtUsername.Text;
// Give the login password
//srvConn.Password = txtPassword.Text;
Hope it will help you a lot
|
|
|
|
|
|
how can i show a modal window form at a cordinates
im using vb.net 2005 and im doing something like this
dim oForm as new InvoiceForm
with oform
.showmodal()
.left=txtID.left
.top=txtid.top+txtid.height
end with
t.aransiola
|
|
|
|
|
I think this might be what you are looking for
Dim oForm As New InvoiceForm
With oForm
.StartPosition = FormStartPosition.Manual
.Left = txtID.left
.Top = txtid.top+txtid.height
.ShowDialog()
End With
hope it helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
the problem with your code was order of execution. you need to set the left and top before you show the form because execution stops while the form is shown and continues when the form becomes hidden.
|
|
|
|
|
I am using a datetimepicker in my VB 2005 express application
I wan to
Initialize the DTPicker as per the user input
Restrict the min and max values as per user input
Also keep on changing these settings in the application as user is allowed to change/edit input
I tried using can any one please help me with it
I had tried codes like the following
DTPk_reg_day.Value = New Date(Val(cmb_reg_year.Text), cmb_reg_month.SelectedIndex + 1, 1)
is there any provision of NULL value??
DTPk_reg_day.MinDate = New Date(Val(cmb_reg_year.Text), cmb_reg_month.SelectedIndex + 1, 1)
DTPk_reg_day.MaxDate = New Date(Val(cmb_reg_year.Text), cmb_reg_month.SelectedIndex + 1, DTPk_reg_day.Value.MaxValue.Day)
But i am mot successful in achieving all the requirements at the same time
Is there any ways i can also have a NULL value
|
|
|
|
|
nishkarsh_k wrote: Is there any ways i can also have a NULL value
No. A Datetime cannot be null, nor can any of it's parameters.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
The Microsoft DateTimePicker must be given a value type (a DateTime) and therefore can't accept null values. There are a lot of more or less usable solutions to solve this issue, some can be found here on CodeProject. If a commercial solution is an option, I would recommend Smart FieldPackEditor.Net which has been built from the ground up to solve all the DateTimePicker shortcomings.
|
|
|
|
|
I wish to convert an existing column into a comboboxcolumn at run time. I've bound a datasource to a datagridview programmatically using the adapter.Fill(dataset) method. This fills my grid view but I want to change one of the columns, say column 2, to be a combobox column. I know how to do this by adding a new column or by using the designer at design time but neither of these help me. I need to do this programmitically at run time. I'm using VB2005.
I'm trying to restrict the user's entries for this particular column in the database to a simple list.
anyone could give a sample code to do this for me to study?? Please anybody..
|
|
|
|
|
You cannot change a column at runtime. Once the column has been created, that's it. It stays that way for the life of the column. You have to create a new column to replace the old one with.
|
|
|
|
|
hi,,
i want to show checkbox in datagrid, i used DatagridBooleanColumn
& i binded my datatable to datagrid , in my datatable i have a boolean column also.. And the checkbox is showing too.. but it have tri-state. i also tried to change the allownull property of DatagridBooleanColumn to false, but still it have tri-state.. have any idea...
cheers
Sam GCEM Bahrain
|
|
|
|
|
u can try with Template Grid, just add with Check box filed with the template field 
|
|
|
|
|
Dear All
Now i about to start to make a Remote desktop software like "GoToMyPC" ..etc
but in LAN where i see the desktop of the remote PC and i can open folders or run programs using a client software in each remote PC
My Ques. How to start such program ??
I don't asking for a whole code just the idea
Indeed the most diff. part , is how to open folders or run programs ?? in other how to send mouse events like click DBclick right click drag ...etc to the remote PC ??
thanks all
bye
|
|
|
|
|
|
well sir
it is just more than captureing its screen , i need to control what i see asif i'm sitting on his PC , for example i can open IE then browse any site and download files (ofcouse to his HD) , well i want to make something like the remote desktop of winXP on LAN
I find someone speak that there is an activex/com for microsoft Remote Desktop
any one has any idea thanks
|
|
|
|
|
yes there are some Com, but if you use that one client system will logged off. Do want same like Microsoft Remote Desktop ????
|
|
|
|
|
no ofcourse , i don't want to be logged off !!
So what is the solution??
thanks
bye
|
|
|
|
|
Good Day
I have a structure with a variable cookicontainer
Public Structure UserInfo
Public User As String
Public Pass As String
Public Cok As CookieContainer
End Structure
Check values as follows:
For Each coo As Cookies m_httpwebresponse.Cookies
M_httpwebrequest.CookieContainer.Add (coo)
User.Cok.Add (coo)
Next
How can assign to next httpwebrequest values cookie?
Thanks in advance
fulvio
|
|
|
|
|
This question belongs in the ASP.NET Forum. It really has nothing to do with VB.NET.
|
|
|
|
|
Buon Giorno
Ho una structure con un variabile cookicontainer
assegno i valori cosi :
Public Structure UserInfo
Public User As String
Public Pass As String
Public Cok As CookieContainer
End Structure
For Each coo As Cookie In m_httpwebresponse.Cookies
m_httpwebrequest.CookieContainer.Add(coo)
User.Cok.Add(coo)
Next
come posso assegnare alla httpwebrequest successiva i valori del cookie ?
Grazie in anticipo
Fulvio
|
|
|
|
|
In my grid view control I am displaying all the records in a table stored in data base. I am setting the attribute "AutogenerateDeleteColumn" to true, and I am handling "rowdeleting" event. one of the columns in data base have a file name stored in hard disk. when ever I delete a row, I need to delete that particular file from systems' memory. how can I do this in rowdeleting event ?
how can I fire "rowdeleted" event? is it possible to handle "row deleting" and "row deleted" events in same apllication?
thanks for ur suggestions,
with regards,
kiran
|
|
|
|
|
kadkir wrote: how can I fire "rowdeleted" event? is it possible to handle "row deleting" and "row deleted" events in same apllication?
after u click on delete button , first rowdeleting occured then row delted occured.
if you want to check any condtion before deleteing the try it in "Rowdeleteing" section
|
|
|
|
|
I have some problem .I want to create the menu at run time.User will enter some value into database by another form.the value should appear as new menu.My backend is MS access & front end is VB.net2003
after that,if user click on the menu it should disply the corrosponding report.
plz reply
poonam
|
|
|
|
|
Could you send the code?
So that we can tell you where the problem comes from!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
