|
In my project I have a dataset. In the dataset I have added a parameter in tableadapter's selectcommand. In code how can I modify this parameter?
|
|
|
|
|
Show us your code, and we'll show you how to modify it.
|
|
|
|
|
Well, VB generated the code. Here is what I did:
- Created a data source in the Data Source window.
- Opened up the data source in the Solution Explorer.
- Highlited the Table Adapter on the data source object.
- Modified the Command Text propery by setting a field filter equal to '=?'
- VB automatically generates a Parameter for the field filter.
To populate the data table I do this:
MyTableAdapter.fill(MyDataSet.MyDataTable, companyvalue)
It fills the table with records that match the value of companyvalue.
My questions how can I modify the Commant Text and Parameter in code. After the code modifies this I can change the parameter to something else. For example
MyTableAdapter.fill(MyDataSet.MyDataTable, cityvalue)
|
|
|
|
|
dptalt wrote: Well, VB generated the code.
So, what does the generated code look like? (I don't generate code because it frequently produces garbage that is difficult to maintain)
|
|
|
|
|
Hi,
i m passing a foder name from textbox
i want to know wherther ths folder name is present in treeview or not
plz tell me if u know
sanjaya
sanjaya kumar dhar
|
|
|
|
|
Hi,
I think the possible and fastes solution could be when you are adding nodes in treeview as folder names you also enter the nodes key as same folder name and we know the key is unique in treeview.
so when you try to enter new node with same key it will generate error.
try to trap this error.
if error raised it means the node is alreadt present in the tree.
hope this works.
Nitin...
|
|
|
|
|
hi
i need an example how to open word document from
vb.net and also the dll file (reference)
thanks Eyal
eyalso
|
|
|
|
|
Here are the DLLs
Interop.Microsoft.Office.Core.dll
Interop.Word.dll
I'm not sure what exactly you're trying to accomplish with word, but here is some code which we have doing a merge in word.
Hope this helps
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim wrdMailMerge As Word.MailMerge
MainScreen.lblStatus.Text = "Starting Mail Merge Process"
MainScreen.Refresh()
'open word document and perform mail merge
wrdApp = CreateObject("Word.Application")
wrdApp.Visible = blnShowDetail
wrdDoc = wrdApp.Documents.Open(strToFilePath & strMergeDoc)
wrdMailMerge = wrdDoc.MailMerge
wrdMailMerge.Execute(False)
Lost in the vast sea of .NET
|
|
|
|
|
hi
i ve designed an application in which whenever i enter an amount in a textbox,then that amount will be displaced in the word format of the currency in another textbox.
Eg. if i enter 12225 then it will display as " twelve thousand and two hundred twenty five only"
please help me in this regard.
u can mail me at pradipta_pkc@indiatimes.com
thanks in advance
i m pradip kumar from india,working in vb.net & asp.net
|
|
|
|
|
Asking the same question again and again until yoiu find someone to write it for you is very rude.
All you have to do is Google for it, study the code samples you find, then write the code yourself. VB6 isn't too different from VB.NET. If you know VB.NET, converting the code form VB6 should be very easy.
Your previous post[^]
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I am trying to install a window service through a batch file.
Now i dont want to execyte a batch file, instead i want to write whatever is in the batch file to a command prompt and then execute
Reason is that there are certain variable that will be avaliable only during runtime.
How can we write a command in the command window and execute that.
|
|
|
|
|
I assume you want to write a .NET program to do this 
Have you thought of parsing the batch file and using the appactivate method and sendkeys method?
It wouldn't be the fastest or most efficient way of doing it, but it could work.
<br />
appactivate(ProcessID)<br />
<br />
My.Computer.Keyboard.SendKeys("Keys here", WaitBooleanHere)<br />
I'm not dumb I just have a huge command of thouroughly usless infromation.
|
|
|
|
|
Try this, this is what i have tried.
Dim strBatchFilrPath As String = c:\batchfile.bat
Dim procCMD As New System.Diagnostics.ProcessStartInfo("CMD.exe")
procCMD.UseShellExecute = False
procCMD.RedirectStandardOutput = True
procCMD.RedirectStandardInput = True
procCMD.RedirectStandardError = True
Dim proc As System.Diagnostics.Process = System.Diagnostics.Process.Start(procCMD)
Dim strm As System.IO.StreamReader = System.IO.File.OpenText(strBatchFilrPath)
Dim sOut As System.IO.StreamReader = proc.StandardOutput
Dim sIn As System.IO.StreamWriter = proc.StandardInput
' Write each line of the batch file to standard input
While (strm.Peek <> -1)
sIn.WriteLine(strm.ReadLine)
End While
strm.Close()
Dim stEchoFmt As String = "# {0} run successfully. Exiting"
sIn.WriteLine(String.Format(stEchoFmt, strBatchFilrPath))
sIn.WriteLine("EXIT")
' Close the process
proc.Close()
Dim results As String = sOut.ReadToEnd.Trim
' Close the io Streams;
sIn.Close()
sOut.Close()
|
|
|
|
|
I have been trying to fix some specific errors for some time now and wondering if someone could please help me understand what the mistake here is
1)
Imports System.Data.OleDb
Imports System.Web.Mail
Warning 2 Namespace or type specified in the Imports 'System.Data.OleDb' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
2)
<authentication mode="Windows">
Error 1It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
3)
Inherits System.Web.UI.Page
Error 4Type 'System.Web.UI.Page' is not defined.
|
|
|
|
|
I have an existing Application in vb, which use dao 3.5 to connect Access 97.
On Updation of my database from Access 97 to Access 2003. i got the error "UnRecognized Database Format".
I tried with ADO and database is working well. But i have to use DAO. For this, I Coverted my refernece to dao 3.6 library. But even then i am facing the same error.
Please suggest me a solution for this....
Thanks
Manish
|
|
|
|
|
IMHO, ADO would be the much more preferred method when using databases, fullstop.
HTG
|
|
|
|
|
DAO died a long time ago. Even the latest version (3.6 I believe) won't work with an Access 2003 database. You'll either have to go back to Access 97, or 2000 (I think!), or you'll have to switch to ADO if you want to use Access 2003.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks for ur reply.
It means there is no way to connect access 2003 using DAO. I have to go for ADO.
Thanks
Manish
|
|
|
|
|
Hi,
I have a window form call Form1. I want to create a button that can open calculator in form1. after i open the calculator, it will disable the form1. when i close th calculator, it will enabled form1 back.
My problem is i cant disable the form1...anyone know the solution pls help..
process.start("calc.exe")
i use this code to open the calculator.
|
|
|
|
|
Your code should look something like this:
Dim devenvProccess As Process = New Process()
devenvProccess.StartInfo.FileName = "calc.exe"
devenvProccess.Start()
Me.Enabled = False
devenvProccess.WaitForExit()
Me.Enabled = True
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hi,
Thanks
|
|
|
|
|
Hello everyone,
I am building a new application where my webservices are in PHP and my client application is in .NET. Now more often then not I need to exchange data between the client and the server and some of the data is personal and sensitive. I would like to use some form of encryptiong preferably AES or Rijndael. But the encryption schemes seem to operate differently i both environments. I use .NET 2.0 and PHP 4.3. I tried using the same key and the same plaintext on both the sides but I end up with different encrypted data and neither side decrypts the data generated correctly. Please advise on how I should proceed further...
Thanks In Advance
With Regards
Cipher
Phrozen - 4 - LiFe
|
|
|
|
|
i try to build a CD interface application which combine VB.net and flash, i need to embbed the flash player (flash.ocx) into my application pack so that my application won't depends on the type of flash player installed in the current computer, moreover, my application will able to run, even when there is no flash player instaled,..
any idea about how, thanks for support,..
tears,..
tears
|
|
|
|
|
In the older versions you used to be able to put a * in the version number and the compile action would fill in that number for you.
2005 seems to not allow * in the project properties window anymore. Any ideas?
|
|
|
|
|
You can only put the wildcard in the Build Number (3rd), or Revision (last) position of the Assembly Version.
If you doing this in the My Project Properties, Application Tab, Assembly Information button, you can specify a wildcard for the Build Number by putting an asterisk in the 3rd box for the Assembly Version and clearing the contents of the 4th box. The 4th box MUST be blank for this to work.
Also , when building components or class libraries, it's better to specify the complete Assembly version instead of letting the compiler "fill in the blanks". This is because if you go back and change your component, it will get a new assmebly version number. Default version policy says that an assembly will only work with the components of the version that it was built with. Meaning if you change the version number of one of an applcations components, you either have to rebuild the assemblies that use it to update the the version number that they're expecting, or create a new version policy in the applications config file to override which version the app will look for.
Go to MSDN and search for "AssemblyVersionAttribute Class" for more information.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
