|
The correct statement is:
INSERT INTO TABLE (FIELD1, FIELD2) VALUES ('value1','value2')
The data type must be the same type. For example:
if Field1 = string, Field2 = numeric then
INSERT INTO TABLE (FIELD1, FIELD2) VALUES ('value1',123)
sorry, for my language
I'm still learning
|
|
|
|
|
Thank you but,
The statement is forming correctly, I'm copying the text into query browser and executing
it's working there
|
|
|
|
|
So, show me how you create connection object and command object or take a look at this code:
'MS Access
'Execute = INSERT, UPDATE, DELETE
Public Function ExecuteDbData(ByVal oConn As System.Data.OleDb.OleDbConnection, ByVal sSQL As String) As Long
Dim oComm As System.Data.OleDb.OleDbCommand, oTrans As System.Data.OleDb.OleDbTransaction = Nothing
Dim iRetVal As Integer
Try
oConn.Open()
oTrans = oConn.BeginTransaction()
oComm = New System.Data.OleDb.OleDbCommand(sSQL, oConn, oTrans)
iRetVal = oComm.ExecuteNonQuery()
oTrans.Commit()
Catch ex As System.Data.OleDb.OleDbException
MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error")
Try
oTrans.Rollback()
oTrans.Dispose()
Catch
'do nothing
End Try
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error")
Finally
oConn.Close()
oTrans = Nothing
oComm = Nothing
End Try
Return iRetVal
End Function
'MS SQL
'Execute = INSERT, UPDATE, DELETE
Public Function ExecuteDbData(ByVal oConn As System.Data.SqlClient.SqlConnection, ByVal sSQL As String) As Long
Dim oComm As System.Data.SqlClient.SqlCommand, oTrans As System.Data.SqlClient.SqlTransaction = Nothing
Dim iRetVal As Integer
Try
oConn.Open()
oTrans = oConn.BeginTransaction(System.Data.IsolationLevel.Serializable)
oComm = New System.Data.SqlClient.SqlCommand(sSQL, oConn, oTrans)
iRetVal = oComm.ExecuteNonQuery()
oTrans.Commit()
Catch ex As System.Data.SqlClient.SqlException
MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error")
Try
oTrans.Rollback()
oTrans.Dispose()
Catch
'do nothing
End Try
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error")
Finally
oConn.Close()
oTrans = Nothing
oComm = Nothing
End Try
Return iRetVal
End Function
sorry, for my language
I'm still learning
|
|
|
|
|
Sorry everyone
I figured out that I was working on another dataBase with my querybrowser
I just duplicated the databases and that fooled me in the first place
I wasn't aware of the difference until 3 hours of crisis
sorry for disturbance
thanks for any help
|
|
|
|
|
A few thoughts. First of all, you are leaving yourself wide open to a SQL Injection Attack with this code - use SQL Parameters instead of directly injecting values. Secondly, is it throwing an exception? Set a breakpoint on the code and step through it - see what's happening at this point.
|
|
|
|
|
Hi,
I am using IECore as the renderer. I am able to capture the snapshot of the web content and save it as bmp file (shown below).
To get the content
AxWebBrowser web = new AxWebBrowser();
web.SetBounds(0, 0, 1024, 600);
web.Navigate2(ref URL, ref oNull, ref oNull, ref oNull, ref oNull);
Application.Run();
private Graphics grp;
private IntPtr hdc;
private IViewObject vw;
private IHTMLDocument2 doc;
public void Capture()
{
doc = (IHTMLDocument2)web .Document;
web.SetBounds(0, 0, width, height);
image = new Bitmap(width, height);
grp = Graphics.FromImage(image);
_RECTL bounds;
bounds.left = 0;
bounds.top = 0;
bounds.right = width;
bounds.bottom = height;
hdc = grp.GetHdc();
vw = doc2 as IViewObject;
vw.Draw(1, -1, (IntPtr)0, (IntPtr)0, (IntPtr)0,
(IntPtr)hdc, ref bounds, (IntPtr)0, (IntPtr)0, 0);
grp.ReleaseHdc(hdc);
image.Save(fileName);
image.Dispose();
}
}
I am calling Capture at x fps. What I have observed is, if the application is allowed to run for 30 mins - 1 hrs, the memory increases from 30MB to 600 MB and more and finally the application crashes
I tried forcefully disposing the bitmap and graphics object. But still the problem persists. I am not getting the root cause of the issue.
Any help is appreciated.
|
|
|
|
|
HalliHaida wrote: grp = Graphics.FromImage(image);
you create a graphics (which is an expensive object) and you don't dispose it. That is your problem.
Now why are you creating a new bitmap and a new graphics all the time. You could probably work with just one each, and reuse it over and over, reducing the load caused by your app.
BTW: why do you use axWebBrowser instead of WebBrowser class?
|
|
|
|
|
As well as what Luc has said, there is a potential that the pages you navigate to cause a leak in IE as well. Basically, IE uses reference counting to control when things get collected by the internal IE garbage collector. Certain things, such as unreleased event handlers and badly implemented closures, leave references in the reference counter, so these items never get removed (even if the page is refreshed).
|
|
|
|
|
Thanks a lot for the information.
|
|
|
|
|
|
If what you are saying is that say your KVP list contains:
K1, AAA
K2, BBB
K3, BBB
K4, CCC Then your strings list should only contain 3 elements: "AAA", "BBB", and "CCC", then you need to:
1) Change your array of strings to a List<string> as you don't know how many elements it will contain - you can convert it to an array later if you need to with the ToArray method.
2) Set a string lastValue and set it to the first value, plus the string "Do not match" - this ensures that the first KVP value is transferred to the new list.
3) In your loop, compare the current KVP value to lastValue and if different, use the Add method to add it to your List of strings.
4) At the bottom of your loop, set lastValue to the KVP Value.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
I think this pattern is what you are looking for:
using System;
using System.Collections.Generic;
namespace KeyValuePair
{
class Program
{
static void Main(string[] args)
{
List<KeyValuePair<string, string>> listImport = new List<KeyValuePair<string, string>>();
listImport.Add(new KeyValuePair<string, string>("K1", "CCC"));
listImport.Add(new KeyValuePair<string, string>("K2", "BBB"));
listImport.Add(new KeyValuePair<string, string>("K3", "AAA"));
listImport.Add(new KeyValuePair<string, string>("K4", "BBB"));
listImport.Sort(delegate(KeyValuePair<string, string> first, KeyValuePair<string, string> second)
{
return first.Value.CompareTo(second.Value);
});
string strLast = String.Empty;
List<string> listDistinct = new List<string>();
foreach (KeyValuePair<string, string> kvp in listImport)
{
if (strLast == kvp.Value)
continue;
listDistinct.Add(kvp.Value);
strLast = kvp.Value;
}
foreach (string str in listDistinct)
Console.WriteLine(str);
Console.ReadKey();
}
}
}
|
|
|
|
|
Hi ,
I am submitting a html form in ASP.NET 1.1, to a websphere server. I am browsing excel file and submitting through object to Websphere server, by sybmitting form with action as Websphere hosted address.
Whenever I login to app, and try to upload the file with above functionality, for the first time, I get redirected to Login.aspx automatically. But when I re-login again and does the same thing as above, the file is uploaded successfully.
Can you please help me regarding this, as I have maintained releative values of timeout for session and form-authentication in web.config file.
- Ajay K
modified on Tuesday, October 19, 2010 3:43 AM
|
|
|
|
|
Please try the ASP.NET forum - this is C#
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
hi, I heard that there is a method of using class to get the value from form 1 to form 2 but i not familiar with using class.So is there any advice or reference that you could provide me?
|
|
|
|
|
Hi,
you should read a book about c# and object oriented programming. Here is a solution, but I really think you should read about it so that you can understand it:
Create a form "Form2" in (e.g. in the designer) and use this code in your code behind file (e.g. Form2.cs)
public class Form2 : Form
{
private int m_nValue = 0;
public Form2()
{
}
public void SetValue(int val)
{
m_nValue = val;
}
}
then you can call the public function in your Form1:
Form2 frm = new Form2();
frm.SetValue(1);
|
|
|
|
|
I guess it would be a shared (static) class with a public property that is exposed to the outside world.
If one form has a reference to the other forn, I'd rather use a property within the other form.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
Visit the Hindi forum here.
|
|
|
|
|
Beside the other suggestions you could also just add a constructor to your 2nd form (that you call from your first form) that takes the class of your choice as an argument.
internal class Form2 : Form
{
internal Form2(MyClass obj)
{
MessageBox.Show (obj.Name + " " + obj.Number);
}
}
internal class MyClass
{
internal string Name
{ get; set; }
internal int Number
{ get; set; }
}
In Form1 you call:
MyClass myC = new MyClass();
myC.Name = "John Doe";
myC.Number = 42;
Form2 f2 = new Form2(myC);
f2.Show();
|
|
|
|
|
if i want to get the value of form2 textbox1 to form1 textbox2 what code should i create??
|
|
|
|
|
If you opened Form2 from Form1 , and want to add the value of Form2.textbox1 to form1.textbox2 I would do this using delegates .
Check out this[^]link (Second Scenario) which explains it. Good luck
|
|
|
|
|
|
You can also try making a property as static for FORM1 and then add the reference of FORM1 in FORM2 then with the class name in which you have defined/declared the property as static; you can easily get it by Class Name.
|
|
|
|
|
Not a good idea - there are several much better ways to do this than using static. Consider the same problem when using non-Form related classes: If you use your static solution what happens when there are two instances? What happens when multiple threads are involved?
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
Best Solution: Learn how to program in .NET and OOP. (This is quite a basic problem, I think you didn't understand the concept of instances, scope, access modifiers etc.)
2nd Solution: Follow the advices here (but don't follow the "make a static property" advice!)
Dirty Solution: Just declare your TextBoxes as "public" (you can set the "Modifier" in the VS-Designer).
I'd head for the "best solution" - learn your basics. This will really help you!
|
|
|
|
|
Explain in more detail how Form 1 is related to Form 2. How are each instantiated? In what order are they displayed? Is it always the same or does this change?
|
|
|
|
|