|
You can't use a SQL Server database without SQL Server AFAIK.
SQL Server doesn't come built-in to the .NET framework.
Mark
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://www.codeproject.com/script/Forums/Images/coffee.gif)
|
|
|
|
|
Isn't that like trying to open an MS Excel document without Microsoft Excel? I imagine, if you want, you could open the SDF as a text file and have a look inside, but it won't act as a database without a database server. The clue is in the name - server. It 'serves' the data. The fact that the underlying datastore is a file is irrelevant.
Knowledge is hereditary, it will find its way up or down.
Luc Pattyn
and since what every time when i want to add button to this control one add two times
posted in C# forum
|
|
|
|
|
Ok, Thanks. I will investigate using SQLite as I have haerd that that can be used without a server (I.E Integrated)
Thanks anyway.
|
|
|
|
|
My Paranoid Hubby wrote: anyone else getting sick of this basic question?
Yes, which is why I generally ignore them.
"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
|
|
|
|
|
Right Click your project in Solution Explorer,
Add / Component / SQL Database
You can then use the database as a file in your project.
Kind Regards.
|
|
|
|
|
Well, it sounds like you are using SQL Server Compact Edition 3.5, which means SqlConnection is not what you want. You need to use the System.Data.SqlServerCe[^] namespace. There are a lot of samples out there just for that, like this one[^].
|
|
|
|
|
Hi to all,
I am doing DirectShow Programming in VC++ & C#.Net.
I am using "MPEG-2 Multicast Receiver" filter & using IMulticastConfig interface on it.
In VC++, when I use SetMulticastGroup(ip, port) of IMulticastConfig it sets port properly to the filter.
But when same thing I do in C#.Net (same code of VC++), it fails to sets different port to that filter. (every-time sets a new port. No compilation or run-time error).
For C#.net, IMulticastConfig is written using IMulticastConfig of DirectX 9.0 of VC++.
Following is my interface,
<br />
using System.Runtime.InteropServices;<br />
<br />
[ComImport, System.Security.SuppressUnmanagedCodeSecurity,<br />
Guid("1CB42CC8-D32C-4f73-9267-C114DA470378"),<br />
InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]<br />
public interface IMulticastConfig<br />
{<br />
[PreserveSig]<br />
int SetNetworkInterface([In] ulong ulNIC);<br />
<br />
[PreserveSig]<br />
int GetNetworkInterface([Out] ulong pNIC);<br />
<br />
[PreserveSig]<br />
int SetMulticastGroup([In] ulong ulIP, [In] ushort usPort);<br />
<br />
[PreserveSig]<br />
int GetMulticastGroup([Out] ulong pIP, [Out] ushort pPort);<br />
}<br />
My code is,
<br />
m_MulticastRcv] = Func.AddFilterByName(this.m_GraphBuilder, FilterCategory.LegacyAmFilterCategory, cNetworkInputFilterName);<br />
if (m_MulticastRcv == null) throw new Exception();<br />
IMulticastConfig Inetwork = (IMulticastConfig)m_MulticastRcv;<br />
<br />
m_hResult = Inetwork.SetMulticastGroup(InetAddress("234.1.1.1"), (ushort)System.Net.IPAddress.HostToNetworkOrder((ushort)1234));<br />
DsError.ThrowExceptionForHR(m_hResult);<br />
<br />
m_hResult = Inetwork.SetNetworkInterface(InetAddress("192.168.2.112"));<br />
DsError.ThrowExceptionForHR(m_hResult);<br />
Thanks & Regards,
Aniket A. Salunkhe
|
|
|
|
|
Hey! Guyz i'm newbie in this developing business.
so got sum issues....
please help me to find out the solution.
I'm developing an application that is Counting PagesIndexed, BackLinks and PageRank from various SearchEngines.
My Application is windows based and i'm able to fetch data from search engine. Now! I've to create a<b> Pause Button</b> that is also working as <b>Continue Button</b> and a <b>Stop button </b>to end the process of counting the PagesIndexed,PagesRank, and BackLinks..
Please! Help.......
|
|
|
|
|
if you put your main processing into a separated thread. it will be easier to pause/resume the thread.
Best regards,
Jaime.
|
|
|
|
|
There are 5 functions are getting called for different purposes for a same argument.
when Pause button is clicked, how is it possible to know which function is executed or which one is being executed currently or which one will be executing next. And then pauses the execution till the time it is resumed by again clicking the PAUSE button....
|
|
|
|
|
Assuming your processing is all in the same class, set a class-level flag indicating the pause occurred. Also assuming your processing is being done in a loop, you might try the following:
private: bool pause;
void PauseButton_Click(Object sender, EventArgs e){
pause = true;
}
void ContinueButton_Click(Object sender, EventArgs e){
pause = false;
}
void ProcessFunction(){
while(someCondition){
if(pause){
continue;
}
}
}
or
void ProcessFunction(){
while(someCondition){
while(pause){
Thread.Sleep(0);
Application.DoEvent();
}
}
}
I know some developers are against using Application.DoEvents() unless absolutely necessary, so you may perfer the first method. If you're trying to use the same button for pause and continue, then you just need the one event handler and just toggle your flag:
pause = !pause;
Brandon
|
|
|
|
|
I have created stored procedure for calculating salary.how will i access that procedure using c#.NET
vinoth
|
|
|
|
|
|
Look at that, it can give you an idea )
conn = new
SqlConnection("Server=(local);DataBase=Northwind;Integrated Security=SSPI");
conn.Open();
// 1. create a command object identifying
// the stored procedure
SqlCommand cmd = new SqlCommand(
"CustOrderHist", conn);
// 2. set the command object so it knows
// to execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;
// 3. add parameter to command, which
// will be passed to the stored procedure
cmd.Parameters.Add(
new SqlParameter("@CustomerID", custId));
thanks for everything i have...
|
|
|
|
|
if you are using SQL
then you need
1. import the system.data.sqlclient namespace
2. then create a object of sqlconnection with appropriate parameters
3. then either create a objects of sqlcommand and sqldatareader and in commad specify the storedprocedure name or you can also create a object of sqldataadaptar and sqldataset and in sqldataadaptar you can set your stored procedure name.
if u r working on anyother db than import the namespace and create objects accordingly
|
|
|
|
|
|
if you r using SQL please check the below code
string strSqlConnectionstring = "sqlserver details with provider";
System.Data.SqlClient.SqlConnection _ObjSQLCon = new System.Data.SqlClient.SqlConnection(strSqlConnectionstring.ToString());
System.Data.SqlClient.SqlCommand _ObjSqlCom = new System.Data.SqlClient.SqlCommand();
try
{
_ObjSQLCon.Open();
_ObjSqlCom.Connection = _ObjSQLCon;
// your store procedure name
_ObjSqlCom.CommandText = "Your Store procedure name";
_ObjSqlCom.CommandType = System.Data.CommandType.StoredProcedure;
// you can add parameter as per your requirement
// parameter name & datatype should be as per you have mentioned in your procedure
// set the direction of your parameter
// you need to add output parameter in the same way but direction out be output
_ObjSqlCom.Parameters.Add("your parameter name", System.Data.SqlDbType.Char, 50).Direction = System.Data.ParameterDirection.Input;
_ObjSqlCom.Parameters.Add("your output parameter name", System.Data.SqlDbType.Char, 50).Direction = System.Data.ParameterDirection.Output;
_ObjSqlCom.Parameters[0].Value = "your parameter value";
_ObjSqlCom.ExecuteNonQuery();
// to get the output value you can use either array location of that parameter or the parameter name
// if you are confused then just right click on _ObjSqlCom and view it in immediate window after you have executed _ObjSqlCom.ExecuteNonQuery();
}
catch
{
}
finally
{
strSqlConnectionstring = string.Empty;
if (_ObjSqlCom != null)
{
_ObjSqlCom.Dispose();
_ObjSqlCom = null;
}
if (_ObjSQLCon != null)
{
if (_ObjSQLCon.State != System.Data.ConnectionState.Closed)
{ _ObjSQLCon.Close(); }
_ObjSQLCon.Dispose();
_ObjSQLCon = null;
}
}
if you further douts feel free to email me at ashwin@omtechsolutions.com 
Ashwin Shetty. Mumbai. India
|
|
|
|
|
Hai all,
In my application i am using the code below i mentioned. But it couldn't converted into flv format and its not saved into specified path .Can any one help me to do this using c#.
Process ffmpeg,hai;
string video;
string mpg;
video = Page.MapPath("new clip_04.wmv");
mpg = Page.MapPath("") + "\\video.flv";
ffmpeg = new Process();
ffmpeg.StartInfo.Arguments = " -i " + video + " -s 480*360 -deinterlace -ab 32 -r 15 -ar 22050 -ac 1 " + mpg;
ffmpeg.StartInfo.FileName = Page.MapPath("ffmpeg.exe");
ffmpeg.Start();
ffmpeg.WaitForExit();
ffmpeg.Close();
|
|
|
|
|
Hi all,
I have a image with point(10,10). I can move that image by using mouse when point to location point(10,10). Now, i am using Graphics.ScaleTransform(0.9f,0.9f) to resize the image. My question is,how can i change the location point of that image after resize?(It should not be at point(10,10) anymore,am i right?)
Any idea or hits are welcome.
regards
cocoonwls
|
|
|
|
|
Dear all,
Finally i am find out a way to do that, below is the sample code 
PointF ScalingFactor = new PointF(1, 1);
PointF viewPoint = new PointF((float)(e.X) * (ScalingFactor.X / zoomvalue),
(float)(e.Y) * (ScalingFactor.Y / zoomvalue));
MouseEventArgs WorldPosition = new MouseEventArgs(e.Button,
e.Clicks,
(int)viewPoint .X,
(int)viewPoint .Y,
e.Delta);
Note: Example code refrence from project "DrawToolsForRoman"
regards,
cocoonwls
|
|
|
|
|
I've got the WebBrowser control displaying my html, but it seems to not be able to handle images (I'm using a fully qualified path, and it still doesn't work). What am I missing?
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
are you using the "file" protocol? Like
Best regards,
Jaime.
|
|
|
|
|
That doesn't seem to work either. 
I also just found out that I can't load/apply an external stylesheet...
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
modified on Saturday, October 4, 2008 6:13 AM
|
|
|
|
|
John Simmons / outlaw programmer wrote: I also just found out that I can't load/apply an external stylesheet
That's not true, you can use stylesheets in local html files.
Maybe you have not described your problem clearly.
Best regards,
Jaime.
|
|
|
|
|
private string BuildHtml()
{
StringBuilder builder = new StringBuilder("");
builder.Append("<html>");
builder.Append("<head>");
builder.AppendFormat("<base href='{0}' />", Application.StartupPath);
builder.Append("<style>");
builder.Append("body { font-family:arial; font-size:11pt; }");
builder.Append(".articleTable { width:100%; border:0; background-color:Black; ");
builder.Append(" font-family:arial; font-size:11pt; }");
builder.Append(".darkRowChanged { background-color:#B1E3FF; }");
builder.Append(".lightRowChanged { background-color:#E5F6FF; }");
builder.Append(".darkRow { background-color:#EEE; }");
builder.Append(".lightRow { background-color:white; }");
builder.Append(".descText { font-size:9pt;color:#777;margin-top:3; }");
builder.Append(".titleText { font-weight:bold; font-style:italic; }");
builder.Append(".headerRow { background-color:#999; height:20px; line-height:20px; }");
builder.Append(".dataRow { height:60px; }");
builder.Append("</style>");
builder.Append("</head>");
builder.Append("<body>\n");
builder.Append("</body>");
builder.Append("</html>");
return builder.ToString();
}
this.webBrowser1.Navigate("about:blank");
HtmlDocument doc = this.webBrowser1.Document;
doc.Write(string.Empty);
this.webBrowser1.DocumentText = BuildHtml();
I've also tried the following to get the file:
href="./cpam.css"
href="c:\fully\qualified\path\cpam.css"
I have a feeling that if I can find out why either images won't display or the css file won't load, the whole thing will fall into place. I simply don't know what I've missed here, and finding info with google on this problem is impossible because of the lack of documentation anywhere concerning the webbrowser control.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
