|
I'm using the dataadapter to update the dataset and then I refresh the combobox. The combobox is bound to FilmerDataSet.
I have tried this
Sub deleteRecords(ByVal cbo As ComboBox, ByVal table As String)
Me.FilmTableAdapter.DeleteQuery(cbo.SelectedValue.ToString)
Me.FilmTableAdapter.Update(Me.FilmerDataSet)
cbo.Refresh()
End Sub
and this
Sub deleteRecords(ByVal cbo As ComboBox, ByVal table As String)
Dim cnNwind As New OleDb.OleDbConnection (Me.FilmTableAdapter.Connection.ConnectionString)
Dim cmOrder As OleDb.OleDbCommand = Nothing
Dim strSQL As String = "DELETE FROM " + table + " WHERE ID = " + cbo.SelectedValue.ToString
cmOrder = New OleDb.OleDbCommand(strSQL, cnNwind)
'cmOrder.Parameters.AddWithValue("@Original_ID",cbo.SelectedValue.ToString)
cnNwind.Open()
cmOrder.ExecuteNonQuery()
Me.FilmTableAdapter.Update(Me.FilmerDataSet)
cnNwind.Close()
cbo.Refresh()
End Suband neither works.
Also when do I have to add parameters, that line is a comment.
|
|
|
|
|
OK. It's obvious that you're really, really confused and a beginner at programming in general. You're passing ComboBox's and table names when you don't need either. All you need to pass is the ID selected in the ComboBox. The method you call to delete the record should already know which table it's dealing with. You also don't know how DataAdapters work and your SQL also needs work to support parameters. Describing all of this is way beyond the focus of a forum post and would take a large amount of space.
I couldn't tell you how to fix this because, really, it would involved scraping the code you have entirely, and starting over from scratch. I seriously recommend picking up a beginners book on VB.NET and ADO.NET.
|
|
|
|
|
You don't have to be insolent. I have more than one table and combobox, which are doing the same thing. I know I have trouble understanding ADO.NET, that is why I ask questions. Because I don't see the differences and understand wich method I should use in the books I have read. I'm greatefull for the answers you gave me, but now I have to ask somewhere else to answer my questions.
|
|
|
|
|
I'm trying to write a script that will give a user two options (map network drive, or run SMS) then call a script based on their response. I tried using InputBox but am really looking for a way to have like two buttons to click or a drop down with no typing. Is it possible? Any suggestions\help is appreciated.
Backround (in case your wondering) on the request, we have to remove rights from our help desk staff, but they have to be able to map drives and SMS remote control pc's using a !bang account. Within our call logging software I've created a "run as" button that will be the basis of this request. I welcome any suggestions.
Jay
|
|
|
|
|
JayMar8 wrote: I tried using InputBox but am really looking for a way to have like two buttons to click or a drop down with no typing. Is it possible?
Create a form, drop two buttons on it. In the Click events of those buttons, you launch whatever command line you need to using the Process class.
Either you really need to pick up a beginner's book on VB.NET, or you've left out an important detail that is stopping you from writing this project.
If you're put a button in your call logging software, what's stopp you from putting two more buttons, one for running each application?
|
|
|
|
|
"If you're put a button in your call logging software, what's stopp you from putting two more buttons, one for running each application?"
The reason is the available space on the call logging gui is limited. We may be adding several options to the custom form you suggested I create, so I'd rather it call scripts based on user input. Thanks for you suggestion, I'll see if I can figure out how to create a form. And yes, I do need to pick up a beginners book...
|
|
|
|
|
i want to know the use of timer in vb 6 to create various animated pictures.
|
|
|
|
|
First of all, this isn't a question but a statement. This looks like an order.
To answer your question: I don't know if this is the same in VB6, but a timer has a Tick event. The timer also has an interval that can be set. In VB6, if the interval is 0, the timer is disabled. Showing animations with a timer isn't a very good idea, because it uses a lot of CPU, but it can be done. Also, I have no idea where you are storing the pictures used in this animations. I will use images in a folder in this example.
Public ImgIndex as Integer = 0
Private Sub Timer1_Tick(...) Handles Timer1.Tick
ImageBox1.LoadPicture(Folder & "\Image" & ImgIndex.ToString & ".gif") 'LoadPicture is no longer being supported in higher versions of VB
ImgIndex+=1
End Sub
Yet, this code is far from perfect. When the animation is at it's final image, it will request an image that does not exist. In my example, you could solve this by counting the number of files in a folder, but it's risky.
Hope this helped you,
Zaegra
Motivation is the key to software development.
|
|
|
|
|
I Format datagridview column as currency but when I add data with this code
reader = OleDbCommand1.ExecuteReader()
Dim arr(6) As String
flag = False
DataGridView1.Rows.Clear()
'DataGridView1.ClearSelection()
While reader.Read()
arr(0) = reader.Item("obekt_name")
arr(1) = reader.Item("material")
arr(2) = reader.Item("edin_cena")
arr(3) = reader.Item("kolichestvo")
arr(4) = reader.Item("data_zakup")
arr(5) = reader.Item("cena")
DataGridView1.Rows.Add(arr)
flag = True
End While
not see currency sign, I want see $10000, but see only number 10000. I add data in MS access database using OLE cennection
|
|
|
|
|
um...
arr(n) = Format(reader.Item("myItem"),"$0.00")
I don't speak Idiot - please talk slowly and clearly
I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury
|
|
|
|
|
Thank You very much that work
|
|
|
|
|
I know in vb.net the TYPE is changed to Structure in vb.net
If you need to create new Structure in design time, you should add a module to your project and start building the structure you want.
Suppose you have this Structure
Public Structure strut_Employee
Public ID as Integer
Public FullName as string
End Structure
If you want to get reference to this type, you should code Dim Mytype as struct_Employee
I want to create structure dynamically.
RetStruct = CreateStruct("ID","Integer","FullName","String")
' The parameter are structure components
' CreateStruct should create the structure and return the created structure to RetStruct variable which is defined as structure
' Then I want the ability to use the below
RetStruct.ID = 1000
RerStruct.FullName = "Samir"
Can that be done? Either in vb6 or vb.net
TIA
Samir R. Ibrahim
|
|
|
|
|
In VB6, no, not at all.
In VB.NET, it's possible, but very rarely ever used. I suggest creating a DataTable instead.
Creating a structure at runtime is FAR more difficult that it sounds. You actually have to create the structure using CodeDom, treating it as if you were writing a VB.NET compiler, emitting MSIL code. A structure would be inefficient in this case because you can't reference it anywhere in your code, nor use any of it's members without further using Reflection, which is notoriously slow. Why? Because your structure doesn't exist at compile-time!
|
|
|
|
|
I Understand.
Let me ask the question in other way.
In VFP suppose you have function
Function Myfunc
A = 10
Return A
EndFunc
I can create this function at run time by a command called ExecScript
B = ExecScript("A = 10"+Chr(13)+Chr(10)+"Return A")
? B ' Return 10
Is there is similar function in vb.net?
Samir R. Ibrahim
|
|
|
|
|
Hi,
That is quite different from your original question, and I don't know of a way to do it easily.
Maybe you should tell more about your functional needs without focusing on technical details, and someone will suggest a way to tackle the functional problem.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Hi Luc
Sonce Dave reply to my original question seems like "mission impossible 2" so thought if I can Wrap Around
Dim StrScript as String
StrScript = "Dim MyStruct as strut_Employee"
StrScript = StrScript & "Public Structure strut_Employee" & vbvrlf
StrScript = StrScript & "Public ID as Integer" & vbvrlf
StrScript = StrScript & "Public FullName as string" & vbcrlf
StrScript = StrScript & "End Structure"
MyVar = VBExecScript(StrScript)
Myvar should handle structure same as strut_Employee
Can that be done?
Samir R. Ibrahim
|
|
|
|
|
It is still not clear what you want to achieve at a higher level.
Yes in .NET you could have an app that writes source code to a file or stream, calls the compiler, which then creates a DLL, and then dynamically creates instances from the types in that DLL. It would use reflection.
Of course you can also write a utility program that creates some source files; then build the app including both your normal source files and these autogenerated files.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
OK, you've just stayed focused on the technical details, but haven't said anything about WHY you think you need to do this.
My answer doesn't change. Youre still trying to emit code and execute it. This is a very rare situation, and frankly, not one I've ever seen in a database app.
|
|
|
|
|
This Reply to both Luc & Dave
Thanks to both of you for your time in this post.
I don't have a problem I want to solve.
I am just somehow comparing command from VFP if exist in vb.net
I know that VB6 is not Scripting Language.
I thought that changed in vb.net
as Both of you ask "WHY", I agree with both of you with no good reason
or real problem behind my question.
I am just a little disappointed from vb.net for not having easy command for doing what I want.
Thank you very much.
Samir R. Ibrahim
|
|
|
|
|
The real question is why you would do this. I've been writing code for 23 years and never have had the need to do so.
|
|
|
|
|
I am special case that you HAVE to deal with. 
btw: I did not start asking hard question yet 
As you said twice, and as I confirm twice, I don't have a problem which I want to solve.
Asking "Why" is good question, because it may eliminate the need.
I learn something from you and Luc, the "Thinking/Technique" itself to solve a problem in VB.Net is totally different from thinking when creating in VFP. And I thought I will face trouble just in finding the right language command changing.
Each language has it is limit and capabilities, and I am discovering vb.net possibilities.
I can solve my problem by simple declare all the TYPES I want in a single module and return the TYPE I need by sending the TYPE name as parameter.
I don't know if VB.Net support the creation of FLAT dll. where I can declare a function in a FLAT dll i create as I declare win32 API Function and send the TYPE to it without the need of create a TYPE as constant.
I am organized in my programming approach, I had 1 month started with VB.Net and I am already collecting vb.net code and API not just save them as html in a folder, I am creating a classes in order to make the working with any project more easier.
My next approach after butting the code I collect in a class, is to learn how to create FLAT dll, not COM dll. If I will face a trouble in creating FLAT dll, I will simply go to COM DLL.
That is the real reason why I am asking this question.
The Second reason, is the ability to create DLL(FLAT or COM) created by vb.net and use it in VFP if possible. since VFP does not support TYPE or Construct I would like to know if that is possible.
Thank you for your time and attention regarding my question.
Samir R. Ibrahim
|
|
|
|
|
First, the FLAT dll you're talking about is really a Library DLL. There are two types - normal and .NET. A .NET library DLL is not usable by Win32 functions as is because the managed code compilers in .NET don't support the proper exports required by Win32.
Samir Ibrahim wrote: I can solve my problem by simple declare all the TYPES I want in a single module and return the TYPE I need by sending the TYPE name as parameter.
Bad idea. You normally organize the data model in individual classes or groups of classes that deal with specific parts of your data model. The concept is called encapsulation. You don't put everything in a single module and then tell some creator which type you want. Though that has its uses, it's called the Factory pattern, the way you describe it, you're violating OOP rules.
Samir Ibrahim wrote: The Second reason, is the ability to create DLL(FLAT or COM) created by vb.net and use it in VFP if possible.
It's possible, but not as a library DLL. VB.NET and C# don't support the old Win32 exports you're inferring. You have to attribute the classes you want to expose properly so they're exposed through COM.
|
|
|
|
|
Dave Kreskowiak wrote: The concept is called encapsulation.
That concept is one of the reason of me taking 4 kind of medicine
I had gone through a lot of discussion regarding encapsulation in OOP rule. And I read to much about it. I hope that you don't mind I ask you about this later on.
Dave Kreskowiak wrote: you're violating OOP rules
That is a big assumption to say it so early before you see the code.
As saying "Public variable will break the Encapsulation", which is totally wrong if you mean it as abstract sentence.
Dave Kreskowiak wrote: It's possible, but not as a library DLL. VB.NET and C# don't support the old Win32 exports you're inferring.
Thank you for the information.
I learn new thing from you with every post 
Samir R. Ibrahim
|
|
|
|
|
Hi again
It seem I miss-understand your question.
The point is, create a structure on the fly that can be passed to API calls when the API needs TYPE declaration.
Samir R. Ibrahim
|
|
|
|
|
Hi,
It all depends. What API?
.NET supports dynamic stuff but it is not simple to use it.
If the number of required types is limited (say a subset of the Win32 types) it would be much easier
to predefine those types, that is what everyone is doing when calling native functions from
kernel32.dll, user32.dll, and the like. As an example, look at www.pinvoke.org
If the types are yours, and you are in charge of the code on both sides, then you may consider replacing all those structs by key-value collections, where both keys and values are strings. As far as the interface goes, that could boil down to an array of strings (holding an even number of them),
or even one big string with a separator char as in
"key1=value1;key2=value2;...;keyN=valueN"
Hope this helps.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
