|
Is possible to create an XmlDataSource that has 50 columns merge an sql database with 14 columns into and force the other 36 columns except and false or any value I want with vb.net
Learning to Code
|
|
|
|
|
Mo John wrote: Is possible to create an XmlDataSource that has 50 columns
Sure. Why would you want to? XML is NOT a database despite every newbie's attempt at making it behave like one.
Mo John wrote: merge an sql database with 14 columns into and force the other 36 columns except and false or any value I want
Uhh... what?
|
|
|
|
|
While I'm sure I could easily work out something to do this, I was wondering if there was a function that would add an array of bytes to the end of an existing byte array.
Specifically, I am working on a project where a method takes a byte array as a parameter, where the byte array contains more than just a converted string.
Original C/C++ sample code:
unsigned char buf[10];
int len = 10;
buf[0] = 9;
buf[1] = 76;
sprintf((char*)&buf[2], "%d", groupnum);
I'm sure the answer is obvious, but it's just not hitting me in the face right at the moment. 
(For those interested, this is an example from Avaya's "IP Office TAPI Link Developer's Guide" to build the parameter block for the lineDevSpecific function of TAPI 2.x. I'm working on the project in VB.NET using JulMar's ATAPI.NET wrapper. I'm having another issue with the function call to use the byte array, but that's another matter entirely.)
|
|
|
|
|
I have no idea what you're getting at,but you may want to look into the System.Text.StringBuilder class.
|
|
|
|
|
Use the Array.Copy or Array.CopyTo method to copy the data from one array into another array.
Use the Encoding.GetBytes method to encode a string into a byte array. Example:
byte[] group = Encoding.UTF8.GetBytes(groupNumber.ToString());
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Array.CopyTo is exactly what I was looking for. 
|
|
|
|
|
I'm running a VB6 application that queries an SQL Server 2000 database. I'm facing a weired behavior: sometimes the application get toooo slow while executing a specific query, while the same query executes very fast from SQL Query analyzer. I'm not able to catch when it's becoming too slow.
this application has tooo many users connected in the same time but not all are executing the same command at the same time. the table subject of query has many indexes. the log file of the database is small. this is weired since no one can tell when it executes normally from the application and when it becomes too slow
is there any clue where and what to look for in order to solve this?
thanks  
|
|
|
|
|
i would imagine that one of the tables is getting locked (see http://www.mssqlcity.com/Articles/General/sql2000_locking.htm for locking info) If you are entering data then the SQL Server will lock the row or maybe the table to stop other people changing it will your are to keep integerity.
You can get around it for your query by using the nolock feature
SELECT * FROM TableA WITH (nolock) INNER JOIN TableB WITH (nolock) etc.
Otherwise can you provide more info on what the app does etc
Regards
AKimba 
|
|
|
|
|
I think that akimba is right that a dead lock\delay lock might be occurring. I don't think changing the nolock locking hint will work though since that is the default hint for select statements.
Generally to avoid deadlocks, the tables should be used in the same order when doing updates/deletes/inserts. It's a major pain to come up with this list and stick to it, but by referencing the tables in the same order deadlocks shouldn't occur. Another option possibility might be that you have stored procedures that are using a looping structure to perform table modifications which would also cause blocking to occur).
IE, this could be happening especially if there is a large amount of users doing updates, etc.
Stored Procedure 1:
--update table 1
--update table 2
Stored procedure 2:
--update table 2
--update table 1
Might have to narrow down the places where the locking is occuring and modify just those (bandaid approach) vs. changing everywhere the updates are being used.
--Edit:
Starting recording performance data on the server(s) where the delays are occurring. Should narrow down the table(s) that are problematic. Also may need to review indexes.
Just throwing out ideas.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
|
|
|
|
|
Hello,
is anybody can give me merge modules for crytal reports in VB.net 2005.
|
|
|
|
|
Nope. If you're entitled to have them with your licensed copy if Visual Studio, then you have them on the installation CD/DVD's. If not, you don't have them and noone here is going to risk their money and license giving you stuff you're not supposed to have.
|
|
|
|
|
Hi,
I am having awful trouble trying to use the IMAPI2. All I am trying to do is do display the media in a drive per drive letter and also trying to read an ISO. If anyone can help it would be great.
Thanks
|
|
|
|
|
Hi all,
I an using crystal reports to show the reports.I want to use the pull method in crystal reportie connecting the query and connection string in run time..
how can i paass the database connection string to report??
Dim frpt As New rptformula
Dim rpt As New rptstudent
rpt.SetDatabaseLogon("sa", "nimda")---(here iam passing the login and pwd to login into the tables connected to reports but I want togive the connection string in runtime in pull method)
CrystalReportViewer1.ReportSource = rpt
,i saw database properrty in crytal reports how to use that property
|
|
|
|
|
IIRC you need to give each table in the report the credentials.
For each Table in Report.Datatables
Table.creds = ???
next
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello all,
I want to add a row in datagridview at zeroth index.
its not difficult.... i know
but this new row should have all cells as checkbox. and datagridview is databound.
so, my grid will have checkbox row at first line and rest of the line as textboxcells...
is there any way to do it?
Thanx !
|
|
|
|
|
Hello,
this does not seem be possible. Conversion of boolean values to different datatypes may throw some
errors while inserting values.
Regards,
Allen
Allen Smith
ComponentOne LLC
www.componentone.com
|
|
|
|
|
Need urgent help, Please reply ASAP.
We are working on a VB 6.0 to VB.Net migration project which is using lots of different third party controls for e.g. “Crescent enhanced edit controls” which is provided by the vendor Crescent Quickpack.
In a VB 6.0 code file we have a third party control as “CSTextLibCtl.sitxEdit” which exposes following properties.
Begin CSTextLibCtl.sitxEdit csParticulars
Height = 375
Left = 2280
TabIndex = 4
Top = 240
Width = 1455
_Version = 262145
_ExtentX = 2566
_ExtentY = 661
_StockProps = 125
ForeColor = -2147483640
BackColor = -2147483643
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.24
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Modified = -1 'True
HideSelection = -1 'True
RawData = ""
Text = ""
StartText.x = 2
StartText.y = 6
FirstVisPos = 0
HiAnchor = 0
HiNew = 0
CaretHeight = 13
CurNumDataChars = 0
MaxDataChars = 0
FirstDataPos = 0
CurPos = 0
MaxLen = 0
DataReadOnly = 0 'False
Mask = ""
CharacterTable = ""
End
However when we migrate the form containing this control to VB.Net using migration tool “ArtinSoft” it migrates the code as shown below.
Public WithEvents csParticulars As AxCSTextLib.AxsitxEdit
.
.
Me.csParticulars = New AxCSTextLib.AxsitxEdit
.
.
.
CType(Me.csParticulars,
.
.
System.ComponentModel.ISupportInitialize).BeginInit()
'
'csParticulars
'
Me.csParticulars.Location = New System.Drawing.Point(152, 16)
Me.csParticulars.Name = "csParticulars"
Me.csParticulars.OcxState = CType(resources.GetObject("csParticulars.OcxState"), System.Windows.Forms.AxHost.State)
Me.csParticulars.Size = New System.Drawing.Size(97, 25)
Me.csParticulars.TabIndex = 4
Me.Controls.Add(Me.csParticulars)
.
.
.
CType(Me.csParticulars, System.ComponentModel.ISupportInitialize).EndInit()
(the above code is present in designer form)
As can be seen from the above code snippet out of approximately 30 properties only 4 properties are mapped in VB.Net and rest all are embedded in “OcxState” object.
We wanted to have a one is to one mapping of Third party control properties to VB.Net Custom control (which we have developed) properties. However since no properties are visible in the migrated code we are not able to do the mapping. We even tried to decode the “OcxState” object that is present in the “Resx” file in the Base64 format. However that also didn’t work. Now we are stuck up at this point where untill we have this mapping we wont be able to replace the Third party controls with the VB.Net Custom controls.
We would appriciate any inputs on how to capture third party control properties and their values in the migrated code so that we can establish the required mapping.
|
|
|
|
|
akanchu wrote: Need urgent help, Please reply ASAP.
No. Demanding urgent help around here is rather rude and impolite 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
See if I have this correct.
1. You have a 3rd party VB control
2. You have a self-written VB.Net custom control
3. You are using a 3rd party tool to convert your VB6 to VB.NEt
akanchu wrote: However since no properties are visible in the migrated code we are not able to do the mapping.
Why not? You have the properties (you listed them) and you claim you wrote the custom control. Or is it that you are suprised the convertor doesn't map the VB6 control to your custom control?
Well, I would have been more suprised if it did.
And you expect someone who doesn't have your source code to tell you what to do URGENTLY.
Well, its your code....
Bob
Ashfield Consultants Ltd
|
|
|
|
|
There is nothing that's going to automatically figure out that your custom control is supposed to replace another control and automatically remap the properties. I would have been blown out of the water had this really worked! You'd just going to have to rewrite the code by hand. A conversion tools is not ment to convert code for you guaranteed 100% accurate, even without the goofy replacement of an existing control with another. Coverting code is not a "one-click on a tool" process. Covnerting code, evenusing a tool to do most of it is still a full-blown developement project.
|
|
|
|
|
I'm writing an asp.net web application. I want to filter automated requests that are made from some software.
How can i find out automated requests. I mean how can i differentiate automated request and user made request.
fine
|
|
|
|
|
Perhaps you would get more answers on ASP.NET [^]-forum
The need to optimize rises from a bad design
|
|
|
|
|
Hi, i had developed a application for automatic navigation in URL and save information to disk. I'm using webbrowser control.
All is correct, but, i have a problem!!!
When the application is navigate, 'alert' window is open and the application stop.
How i close 'alert' window in code ???
I supossed the solution is complicate but I'm sure this is possible.
Thanks
|
|
|
|
|
Hello gurus 
the funny little problem now comes from a timer component. The main code starts the timer (interval 1) and - right afterwards - a BackgroundWorker component. I intend to count the seconds which the BW needs for his task.
Realizing that the time-label in my form wasn't updated (through 'lblTimer.refresh' in the Timer_Tick event), I stepped through the code and had to see that the Timer_Tick event just isn't called at all   and even a stopmark I placed within the event was ignored. Searching for possible reasons didn't bring me much further yet.
My question: Is there anything (apart from stopping the timer) that makes VB ignore the Timer_Tick event completely? Or are there any imaginable reasons for that behavior?
Thank you for inspiration,
Michael
|
|
|
|
|
Most likely the timer isn't enabled or Timer_Tick event isn't wired.
Also reconsider if you really need interval of 1 millisecond.
The need to optimize rises from a bad design
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
