|
If you are using SQL Server then you can use a Stored Procedure[^] to populate both tables at once. You can also separate SQL commands with a semi-colon so that you can put two SQL commands into one SqlCommand object.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
 i am trying to play a wave file when phone is connected in an outgoing call.i have tried the following code:
no error occurs in the code but the code does not play an audio...
private void tapieventhandler(object sender,eventargs e)
{
....
case TE_CALL_STATE :
ITCallStateEvent cse=(ITCallStateEvent)sender;
if (cse.State = CALL_STATE.CS_CONNECTED)
{
ITBasicCallControl2 bcc = cse.Call;
ITTerminalSupport ts = ia[i];
ITTerminal fpbt =
ts.CreateTerminal(TAPI3Lib.TapiConstants.CLSID_String_FilePlaybackTerminal, TAPI3Lib.TapiConstants.TAPIMEDIATYPE_MULTITRACK, TAPI3Lib.TERMINAL_DIRECTION.TD_CAPTURE);
ITMediaPlayback mp = fpbt;
object audiofile(1);
audiofile(0)="file name";
mp.PlayList=audiofile;
bcc.SelectTerminalOnCall(fpbt);
ITMediaConrol mc=fpbt;
mc.start();\\will start playing the audiofile.
}
break;
.....
}
is there any specific requirements to play an audio?
if yes, then please send me it...
plz send your reply as early as possible.
i have to submit my project before the end of this month.
|
|
|
|
|
Hi
How i can insert into one column of gridview dropdownlist?I need it this list to take data from sql for example name of printer.
good bye
best regards
|
|
|
|
|
Hi,
can anyone help? I have some question on how the webCam works and how to retrieve images from it. I try to get the image and display it on the Web.
Questions :
1. Where does webCam stores the images captured? Or Do I need to specify a Folder for the WebCam to deposit the images captured?
2. How to use C# code to retrive images? where to retrieve the images?
3. Are all images captured by webcam will be in order according to time?
Please help.
Thank in advance.
|
|
|
|
|
I have the same dilema, but, if you don't mind using COM objects, there's a very good ActiveX that I use in VB and it works for me in C# also. It's a free object. It's call exVidCap.ocx. Look for it on the web. http://www.shrinkwrapvb.com/ezvidcap.htm[^]
Regards
-- modified at 11:59 Monday 10th April, 2006
|
|
|
|
|
Hi,
can anyone help? I have some question on how the webCam works and how to retrieve images from it. I try to get the image and display it on the Web.
Questions :
1. Where does webCam stores the images captured? Or Do I need to specify a Folder for the WebCam to deposit the images captured?
2. How to use C# code to retrive images? where to retrieve the images?
3. Are all images captured by webcam will be in order according to time?
Please help.
Thank in advance.
|
|
|
|
|
Hello Experts,
I want to read .cer file generated by RootCA. I want to encrypt scramble it with some garbage data and make .cer file unsuable, then I want to remove the garbage data from .cer file so it could be useful again.
I wanna do it because if I give anybody a .cer file to install it on some machine, he should not be able to steal it. The only way this .cer file could be installed in Authority Store is by my program which gets the confirmation before removing the garbage data from a webservice and sends that webservice client's IP and username.
I tried opening the file in C and C++ both couldnt read the file. Can I do it in C#. If I can then how?
Thanks Alot in Advance
|
|
|
|
|
Hi,
I need to write an error reporting tool. Part of its logging mechanism is querying all installed software and hardware from the system. Can anyone point me to a way to query information about the software packages installed on a computer in C#?
Code project features a nice article explaining how to query the hardware (http://www.codeproject.com/csharp/hardware_properties_c_.asp)
But I would need to query installed software packages too. Any help is appreciated.
Thanks in advance
Ingo
|
|
|
|
|
You could look into the registry under the key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall.
Basically everything listed under control panel/Software is listed there (including name, manufacturer, version...).
You can access the registry via the Registry class in the Microsoft.Win32 namespace.
|
|
|
|
|
Thank you for the hint.
Regards,
Ingo
|
|
|
|
|
Hi
I am opening a Powerpoint application on winform.
i am using a button onclick on that button a slide is inserted and i want to insert a oledbobject "word document" in that slide i am writing the code for that but its not taking the exact class name and giving the COMException(0x80004005) ..
the code is here
using Word = Microsoft.Office.Interop.Word;
using ppt = Microsoft.Office.Interop.PowerPoint;
// here winPptControl_main1 is the usercontrol in which
//Powerpoint application is openend...
ppt.Presentation objPres = winPptControl_main1.presentation;
ppt.Application ppApp = objPres.Application;
ppt.Slides objSlides;
ppt.Slide objSlide;
objSlides = objPres.Slides;
objSlide = objSlides.Add(1, ppt.PpSlideLayout.ppLayoutTitleOnly);
Word.Document wd = (Word.Document)objSlide.Shapes.AddOLEObject(150, 150, 480, 320,
"Opusapp", "",
MsoTriState.msoFalse, "", 0, "",
MsoTriState.msoFalse).OLEFormat.Object;
i am not finding the exact class name to open the word document i have tried MSWord.document to instead of Opusapp but its giving the same error ..
if anybody knows the solution pls let em know ..
thanks...
|
|
|
|
|
how can we edit xml file runtime using dataset?
rahul
|
|
|
|
|
|
Hello!
I am trying to catch a reminder and incoming mail of the outlook...
I am able to catch them, but the problem is that I can't see the content
of the mail, or the content of the reminder...
Maybe someone knows how I can check it?
(I'm programming in .NET 1.1)
Any help would be appreciated!!!
Thanks in advance!
|
|
|
|
|
Hi,
I am getting a byte array from a string using Encoding.UTF8.getBytes(string) function. Now i convert it to a string using Encoding.UTF8.getString(byte[]). Now when i convert it back to byte array using above mentioned function,i don't get the same array that i used when converting to string. Please guide me in this regard.
Waiting from replay...
|
|
|
|
|
If that is really so, it sounds like something that is very specific to what you are doing. I'm not even convinced that the unicode conversion is the actual problem.
Can you show an example that will produce this unusual behaviour?
---
b { font-weight: normal; }
|
|
|
|
|
hi
im using axAcroPDF to display the Pdf file on my windows form. im able to display the pdf file in my form but i dont want the tool bars of PDF file to be displayed. i just want the pages of PDF file. how can i customize this?
Rajanikanth A.B
|
|
|
|
|
I am opening a MS Word document using the following C# code.
Word.ApplicationClass WordApp = new Word.ApplicationClass();<br />
<br />
if (this.openFileDialog1.ShowDialog() == DialogResult.OK) <br />
{<br />
object fileName = openFileDialog1.FileName; <br />
object readOnly = false; <br />
object isVisible = true;<br />
<br />
object missing = System.Reflection.Missing.Value;<br />
<br />
WordApp.Visible = true;<br />
<br />
Word.Document aDoc = WordApp.Documents.Open(ref fileName, ref missing,ref readOnly, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref isVisible);<br />
<br />
aDoc.Activate();<br />
}
This works fine and it opens the document in MS Word separate from the C# application. Is there a way of hooking an event to the document object (aDoc) so that when the word document is closed the C# application can react to the event?
Thanks
Kobus
|
|
|
|
|
Hi.
You should see the common task in windows XP, that appears in left side of all windows(like My Computer , My Documents , ...), and when in a window (My Computer, for example) at "Tools menu -> Folder options ... -> General Tab -> Show common tasks in folders" is selected, it appears.
OK?
I need a control like this to use, that has several portions and each portion expand and enclose like common tasks.
Anything can help me?
Best wishes
|
|
|
|
|
There are several samples here on CP. I cant recall what they are called, perhaps 'Collapsable Control/Container'.
|
|
|
|
|
|
i am using command object where i execute an insert statement,it executes fine but when i open the table then there is no data present. iam using client mode sql database in visual studio 2005.
please help me 
sunny
|
|
|
|
|
Then it's either not executing fine, or you are not looking for the data in the right place. A normal input statement either adds a record or causes an exception when it's executed.
So, most likely you are mistaken in some way, and one of these three things happen:
:: The query is not executed at all.
:: There is an exception, but your code is catching and ignoring it.
:: The data is there, but you look in the wrong place.
---
b { font-weight: normal; }
|
|
|
|
|
hi all,
What is the most Efficient way when using Data Reader and DataSet.?
I have read some articles and they says that Data Reader is Efficient than DataSet.
Now I m giving two samples using DataReader and DataSet.
sample 1 using DataReader)
SqlDataReader dataReader=sqlCmdGetFareList.ExecuteReader();
while(dataReader.Read())
{
FareList farelist = new FareList();
farelist.FareID= dataReader.GetInt32(0).ToString();
farelist.AirlineName = dataReader.GetString(1);
farelistArray.Add(farelist);
}
I'm going to do same procedure using DataSet.
sample 2 using DataSet)
DataSet lobjDataSet=new DataSet("Temp");
DataTable lobjDataTable=new DataTable("DTTable");
SqlDataAdapter lobjSqlAdpt=new SqlDataAdapter(_sqlComm);
//fill DataSet
lobjSqlAdpt.Fill(lobjDataSet);
//fill dataTable
if(lobjDataSet.Tables.Count>0)
lobjDataTable=lobjDataSet.Tables[0];
foreach(DataRow dr in lobjDataTable.Rows)
{
FareList farelist = new FareList();
farelist.FareID= dr["FareID"].ToString().Trim();
farelist.AirlineName = dr["AirLineName"].ToString().Trim();
farelistArray.Add(farelist);
}
In theory says that dataReader is fastest than DataSet.but in here you can see that there is loop in both Sample 1 and Sample 2.
So when considering entire code in sample1 and sample2, can any one please tell me what is the fastest and efficient way to data Retrieve from DB?
Thanks in advance...
|
|
|
|
|
The first one, of course.
The data adapter is basically just reading the data and creating an object structure in memory containing the data. As you are not using any of the added functionality of the data set, this is only wasting time and memory resources.
---
b { font-weight: normal; }
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
