|
Probably by using prepared statements. It's a bit hard to say without a little more information on what you're inserting.
|
|
|
|
|
Yes i am using prepared statement. Based on listbox selection(can be one or two or three .). i have to insert these value or values along with other information. my problem is i am fetching listbox's values through loop. But how i can insert it in a single insert statement. Please Help..
regards
imran khan
|
|
|
|
|
As I said, it's hard to say without seeing what you're actually doing, I don't know what your query looks like so I can't really comment on how you should do it.
At a wild random guess I'd say setup your statement and parameters before your loop then add parameter values inside your loop, execute the statement after the loop.
|
|
|
|
|
Hello all!
We are working with a partner to integrate customer systems with eachother through EDI. The partner has a solution with translates XML messages to EDI messages and vice versa. All is going well with the translation from XML to EDI. In fact, if you consider the XML standard, all is going well with the translation from EDI to XML. The problem lies within the XML support of the Microsoft MBS Nav software.
The standard XML allows that the order of the attributes in an element varies with every message. For example:
<xmlelement attrib1="1" attrib2="2">
is considered the same as
<xmlelement attrib2="2" attrib1="1">
as far as the standard is concerned. MBS Nav however cannot handle these situations.
I know that .NET 2.0 has decent XML support. I also know a thing or two about C# and .NET. What I don't know, if there is an easy way to generate a XML file with a predetermined order of elements and attributes. I heard something about xsd schemas, but I have never worked with these things before.
Any pointers into a direction are highly appreciated! Thanks in advance.
Behind every great black man...
... is the police. - Conspiracy brother
Blog[ ^]
|
|
|
|
|
Creating a schema for your xml is the path to take. There are plenty of resources available, online, books, articles, etc. that can guide you.
only two letters away from being an asset
|
|
|
|
|
Additional to what Mark said, you might want to take a look at this tutorial
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Thanks for the information. I'll look into that!
Behind every great black man...
... is the police. - Conspiracy brother
Blog[ ^]
|
|
|
|
|
Guys,
I have a date time picker which shows the month in words. (eg 13 January 2006).
When I start the exe a parameter will set the current culture to another language and translates all the labels.
The datetimepicker however doesn't change. I've searched throuhg the properties, but couldn't find anything regarding cultures or languages.
Is it possible to change the language/culture of the datetimepicker WITHOUT changing the regional settings?
Many thanks...
V.
If I don't see you in this world, I'll see you in the next one... And don't be late. (Jimi Hendrix)
|
|
|
|
|
Hi all,
been searching for an answer but cannot find one, so i'm asking 
I created a simple custom control (a panel with a header on it). I added the control to my toolbox and when i drag this on my form everything is ok.
But now i'd like to drag a listview control onto my custom panel. This is where it goes wrong. The listview control is not added to my custom panel but to the main form. So when i set the listview's dock style to fill, it fills up the whole form and not my custom panel.
Somehow i've got to handle this in my custom control code, but haven't got a clue.
I'm hoping someone can give me the solution or point me in the right direction.
thank you for helping me out here.
|
|
|
|
|
Hello
Are you sure that the Listview is contained by your custom control? If you don't know it you can check it in "View" option menu. In the "other windows"... there's an option which shows form's control schema...
|
|
|
|
|
il_masacratore wrote: Are you sure that the Listview is contained by your custom control?
no it's not contained. how do i make it contained ?
thanx.
|
|
|
|
|
hi
I was writing windows service. There were 2 services each for client in C# and server in VB.NET. I can't send data from client to server. i am getting the error ' The connected party actively refuses'.I made an application with the same code and it worked fine. the service is working in Local system account.Can anybody help please................
|
|
|
|
|
I've been bulling my hair out to resize the image.
I would like to place an image on the page. the image url is fetched from the database.
I want to resize the image according to the image holding panel. Means.. the image loaded must be loaded in some fixed size. If the image size is less than the fixed size then it has to be streached using some ratio(height and width). otherwise, it has to be resized to the fized size. Otherwise I have to calculate the image width and height of the image and can alert the user that the image size is not enough..
Please Help me out..
Thank You..
Regards,
Stanly.S
|
|
|
|
|
|
|
i just want a system tray that runs 24 hrs even when the computer restarts.
thank you for your help in advance.
|
|
|
|
|
Why didn't wait for an answer to your first post 
only two letters away from being an asset
|
|
|
|
|
He waited a full 15 minutes  before posting the same question in a different form.
|
|
|
|
|
i have a windows service which need to be control by a windows apllication i.e the system tray. in the installer class of windows service i had a code that starts the system tray process and it works fine until when i restart my computer after restarting my computer the windows service as it should be starts automatcilly but not the system tray
apllication.
then for this i added a thread onstart method of windos service . but it seems the system tray application only starts on the background. it does not go where it should go. does any one have any idea.
here is my code plz do not complain abt the path.myproc is instace of class process!!!plz do help . nye the way it works well on windows application.
protected override void OnStart(string[] args)
{
this._applicationLaunchThread= new Thread(new ThreadStart(myproc.StartProcess));
this._applicationLaunchThread.Start();
}
public class Process
{
public Process()
{
//
// TODO: Add constructor logic here
//
}
bool _isnotexist;
public void StartProcess()
{
if(CheckProcess())
{
MyTimerSrv my= new MyTimerSrv();
try
{
System.Diagnostics.Process.Start(@"C:\Program Files\servicetracerclient\WindowsApplication1");
// my.AddToError(" application launch reached");
Thread.CurrentThread.Abort();
}
catch(Exception Ex)
{
MyTimerSrv myt= new MyTimerSrv();
myt.AddToError("application launching error");
myt.AddToError(Ex.Message.ToString());
}
}
}
public bool CheckProcess()
{
MyTimerSrv my= new MyTimerSrv();
try
{
System.Diagnostics.Process[] processes;
processes = System.Diagnostics.Process.GetProcesses();
foreach (System.Diagnostics.Process instance in processes)
{
if(instance.ProcessName.ToString()=="WindowsApplication1")
{
_isnotexist=false;
break;
}
else
{
_isnotexist=true;
}
}
}
catch(Exception ex)
{
my.AddToError("exception of process");
my.AddToError(ex.Message.ToString());
}
return(_isnotexist);
}//end of method
}
|
|
|
|
|
If you just want to start your service automatically, just go to Control Panel -> Administrative Tools -> Services -> Select your service, click on Properties, then set to "Automatic". It will be started everytime your windows start.
|
|
|
|
|
Hi,
Anybody have idea about how to save visual component created in c# into a
file as an image(any type)? Please let me know the solution............
By,
Shivaprasad
|
|
|
|
|
|
oh........its good one. But it's not the solution for my problem. I created one visual component in c# and i can use it on windows form. But i want to provide one public interface to save that component only in any file as an image. So could anybody help me in this regard.
Waiting for your help............
Shivaprasad
|
|
|
|
|
hi
i want to use dataRow for insert,update and delete records on Client/server dataBase.
my question is can i use dataRows instead of Sql Transactions ?
for Example :
DataRow newRow = this.dataset1.tables[0].NewRow();
newRow["name"] = this.textbox1.text;
this.dataset1.tables[0].rows.Add(newRow)
adapter1.Update(this.dataset1);
(because when i use dataRows Instead of SqlCommands, visual Studio needs a valid Insert,Update or Delete Commands) and i think that i can use DataRows Instead of
SqlTransctions,what is your Advice ?
thanks
-- modified at 7:08 Wednesday 13th December, 2006
|
|
|
|
|
Considering a DataRow and a Transaction are completely different things, I cant understand what you are asking.
DataRow - represents a row within a DataTable and stores values for each column within that table
Transaction - A way of executing multiple queries against a database and either commiting all changes or rolling back all changes.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
