|
Set the rowstate of the offending row to deleted
use a dataview to populated the datagrid
set the dataview filter on the rowstate
|
|
|
|
|
I get an error >
Line 1: Incorrect syntax near 'Username'
When i run the code below
hdstr = "SELECT Password FROM LogIn WHERE Username='" & UsernameTextBox.Text & "'"
hdcmd = New SqlCommand(hdstr, hdcon)
hdcmd.Parameters.Add(New SqlParameter("Username", UsernameTextBox.Text))
Dim usr As String = hdcmd.ExecuteScalar()
Please help.
JESA
|
|
|
|
|
hdstr = "SELECT Password FROM LogIn WHERE Username= @UserName"
hdcmd = New SqlCommand(hdstr, hdcon)
hdcmd.Parameters.Add(New SqlParameter("@Username", UsernameTextBox.Text))
Dim usr As String = hdcmd.ExecuteScalar()
|
|
|
|
|
Thank You.
It worked.
JESA
|
|
|
|
|
I'm having problems understanding why a loop is needed to read from a deflated stream. i've replaced the read all bytes in stream method with the following line, however the data in the output buffer is 1 byte smaller than it was before the data was compressed:
Return stream.Read(buffer, 0, buffer.Length)
used to be:
Dim offset As Integer = 0<br />
Dim totalCount As Integer = 0<br />
While True<br />
Dim bytesRead As Integer = stream.Read(buffer, offset, 100)<br />
If bytesRead = 0 Then<br />
Exit While<br />
End If<br />
offset += bytesRead<br />
totalCount += bytesRead<br />
End While<br />
Return totalCount
the full code for this is taken from http://msdn2.microsoft.com/en-us/library/system.io.compression.deflatestream(VS.80).aspx[^]
|
|
|
|
|
The Read method doesn't have to read all data that you request. It returns the number of bytes actually read, so you have to loop until you have filled the buffer or until the method returns zero.
Dim offset As Integer = 0
Dim bytesRead As Integer
Do
bytesRead = stream.Read(buffer, offset, buffer.Length - offset)
offset += bytesRead
Loop Until bytesRead = 0 Or offset = buffer.Length
Return offset
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Hi
This is Rajesh. I developed a vb 6.0 application. In that i want to access my database server table via web service in vb.net 2005.
I tried some methods for last two weeks.Please someone assist me
Thank you
c.Rajesh B.E
|
|
|
|
|
Google results for "vb6 calling a web service[^]". Since VB6 doesn't natively support this, you have to use other libraries and coerce a solution into working.
Some these involve using the native web service support built into the .NET Framework and writing a component in VB.NET that is exposed to COM, and writing the VB6 code to use that component. Other's depend on using various SOAP libraries to do this.
No, I don't have any examples. I stopped using VB6 the day I got my hands on the .NET Framework 1.0 Beta 1, some 6-7 years ago.
|
|
|
|
|
I've used the MSXML3.DLL libraries with no problem at all.
Just download the file. You can also get the SDK version. Once you have the file, set a reference to it. View its methods in the object browser and you can read the docs online.
modified 27-Feb-21 21:01pm.
|
|
|
|
|
I have a VB 6.0 exe. It reads data from an excel spreadsheet and writes to it as well. So, the excel spreasheet is like a database for it. Presently, the spreadsheet resides in a LAN.
Now I want to "INJECT" the excel spreadsheet into the executable, so that the excel spreadsheet is not a separate entity anymore, and is a part if the executable itself. Basically, how can I turn it into an intrinsic application resource?
Can someone please shed some light on how I can do this?
Thanks.
ASP - AJAX is SEXY. PERIOD.
|
|
|
|
|
The short answer is, you can't. An .EXE, when running, cannot be modified.
The entire idea, though noble, isn't practical. You should be seperating code from data, not integrating it.
|
|
|
|
|
Thanks Dave. I understood that.
Actually, I intend to hide the excel spreadsheet from the user. And when I say hide, I don't mean just physically (as in changing the file attribute to hidden), but logically as well. I.e., the user should not be aware at all that there is an excel spreadsheet involved.
With that said, is there a way to covert the spreadsheet into a resoucre of some sort? Like a dll or something which will contain the spreadsheet.
Everytime the exe runs, the EXE will "upack" the spreadsheet from the resource and when done editing, it will "repack" it into the resource. Any clues regarding this mechanism?
Sorry for such vague statements, but I think I've captured the essence this time.
Thanks.
ASP - AJAX is SEXY. PERIOD.
|
|
|
|
|
Bulky Fellow wrote: Everytime the exe runs, the EXE will "upack" the spreadsheet from the resource
Yeah, putting the sheet into a resource is no problem - at compile time.
Bulky Fellow wrote: it will "repack" it into the resource.
Putting it back into the .EXE or .DLL at runtime is the problem. Using normal methods, once the .DLL is loaded, the file is locked until the termination of your app. Again, it can't be modified.
You MAY be able to gleen something useful from the app in this[^] article though. It copies resources between .EXE's and .DLL's, but there's a lot of hoops to jump through.
|
|
|
|
|
Hi, i have developed net browser in vb.net, using webbrowser control. My problem is, when i click on go button for navigating the url, if there is no internet connection is available, or server is not reponding, the webbrowser will show the default page of Internet Explorer that is page not found. i want to use my own page instead of this default Internet Explorer page,how can i do this???
thx in advance....
King
|
|
|
|
|
You've developed a new browser using the supplied web browser control? Why?
|
|
|
|
|
Hi,
As the tile says. this column will be used to specify a file path, so the user will be given a choice to write manually a file path into the textbox column or click a button inside that column and a openFileDialog will appear...
This interface is used in SQL DBMS programs, when you are attaching a database, the same dataGrid is used to locate ldf and mdf files...
Thank you!
|
|
|
|
|
You'll have to make you're own DataGridViewColumn for this. A full explanation of doing this is way too much for a couple of forum posts. There's simply too much detail to cover.
Search for articles on the subject of "Custom DataGridViewColumn". Results[^]
|
|
|
|
|
how do u fill up columns and make changes in it using grid view?
|
|
|
|
|
to fill a datagrid you attach a datasource
Utilise the edit controls to make changes to the data in the grid
Do some research - the question indicates you have done no work towards getting this knowledge.
|
|
|
|
|
hai,
i am using dotnet2005.i do my project in vb.net windows application.
if there are 4 rows,if i delete slno 2,the slno 3 will automatically changed as slno 2,then slno 4 will automatically changed as slno 3.
for ex,
there are 3 columns and 4 rows are displayed in datagridview from sqldatabase,
slno name city
1 guru cbe
2 ram salem
3 balu trichy
4 mahesh cbe
if i delete slno 2 means,the slno 3 will automatically changed as 2,then slno 4 will automatically changed as 3.
after i delete slno 2 means,i want to display in datagridview from sqldatabase like following,
slno name city
1 guru cbe
2 balu trichy
3 mahesh cbe
is it possible,if possible means how to do these.
or any other way to do these or any options in datagridview to generate slno with starting no 1 or using programmatically can to do these.
so any way i want to generate slno.i want in windows application.
|
|
|
|
|
This is automatically what happens, unless the number you're showing is an id from the database. If this is so, it cannot be changed, not easily. Just show a number other than the Id, if you want to show a row number.
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 )
|
|
|
|
|
now i remove slno from database...i tried to genarate slno in datagridview...there is any option to generate slno in datagridview...or how to put row number....so i want to genarate slno or to put row number...
|
|
|
|
|
Hi All,
Iam using ShellExecute API function to execute the file.
File may be any type.
I want to get the Process ID(PID) of the particular file which i executed.
I already tried Shell command, but it isn't work.
Thanks & Regards
Kumaran
|
|
|
|
|
Process.Start will return the handle. Assuming this is VB.NET.
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 )
|
|
|
|
|
Thanks Christian Graus.
but i need in vb6
Thanks & Regards
Kumaran
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
