Comments by DEB4u (Top 50 by date)

Does it matters like.. 175 to 25 compression...

and my computer has a static ip address

Oh.. It doesn't support in XP..

it worked for setting the database password :
conn = New SQLiteConnection()
conn.ChangePassword("password")
..

It sets the password.. but how to remove the password?

password protected

thanks

regarding security: A sqlite .db file can be opened in some sqlite browser, so how it can be secured?

Regarding update: let me be more specific,i.e. when i'll give update means the application will be updated like patches it'll install which may updated the database file.. or any other option?

I'm giving the update location as 'ftp://ipage.intefe.com/mwsm' . but it's showing error..Can u elaborate it?

http://imageshack.us/photo/my-images/685/screenshotr.gif/

http://imageshack.us/photo/my-images/231/screenshot2z.gif/

I've given a wrong query to raise an exception and make the 'er' variable as 'true' .. but it's showing 'er' as 'false'

have a lok at this code...

Public Class Form1
Dim gc As New mysql_con
Dim que As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
gc.conn()
gc.con.Open()
MsgBox("connection opened")
Dim cmd As New MySqlCommand
cmd.Connection = gc.con
que = "insert into testing values ('" + TextBox1.Text + "','" + TextBox2.Text + "')"
cmd.CommandText = que
cmd.ExecuteNonQuery()
MsgBox("...")
que = "insert into testing2 values ('" + TextBox2.Text + "','" + TextBox1.Text + "')"
cmd.CommandText = que
cmd.ExecuteNonQuery()
gc.con_Close()
MsgBox("closed")
End Sub

I'm disconnecting the internet on this step:

MsgBox("...")

but when I check my database, the 1st statement is executed, it's not being rolled back..

Thanks for Reply..

Ya the images are added to the resource file. It's showing a runtime error.

Thanks for yr reply, Actually in the statement
mytransac = con.BeginTransaction

the 'con' is an instance of mysqlconnection which is created in connection class.

Thank you,I got you, but that's ok for some code no for a name but I'd like to ask, if the column is just a serial number which need to be incremented , in that case what'd I do?

ok, so what'd I do have a separate thread for my functions inside a class?

thanx for yr reply... Can I make my access() and con() procedures in side thread like this..

Dim thread as New Thread(new ThreadStart(access))
thread.Start()


Thanx

ya, thanks

i'm asking for a procedure by which I can handle all the 100 button click event in 1 function without using switch case.

Private Sub Button_Click(sender as object, e as ButtonClickEventArgs) Handles, Button1.Click, Button2.Click, etc...

This thing is not working as the buttons are created dynamically.

Thanx

Can you explain the tag Route in some details?

When I'm using this....
Dim cControl As Control
Dim x As Integer = 0
For Each cControl In Me.Controls
If (TypeOf cControl Is Label) Then
If (x >= 21 And x <= 50) Then
cControl.Text = "abc"
End If
x = x + 1
End If
Next cControl


It's changing labels 171-188 to "abc"

It's showing Ambiguous column 'AgentId'....

Can i writeby using 'connect by prior' like this..
"select Agent_Id from agents_details connect by prior Agent_Supervisor_Id=Agent_Id and Agent_Supervisor_Id>0 where Agent_Id=@aid1"

but i's showing error..

Here i'm having 3 levels of iteration...How can i do that?

ya u r right... let me go through it...

this link does not work..

I'm having a function to check internet connectivity...as it has return type so can't use as a thread...Needs some help as new to .net...

Yes i got a function which checks internet connectivity...but i want that this should run always...

thanks a lot....

i need to the result of those 2 query in 1 table...

Actually facing prob in join...Here s 1 query : "select agents_details.Agent_Employee_Id,agents_details.Agent_Id from agents_details where Agent_Employee_Id=any(select Emp_Id from employee_status where Emp_acc_Stat='OPEN') "

and another is: "select Employee_Id,Emp_Name,Emp_Mname,Emp_Lname from employee_details where Employee_Id=any(select agents_details.Agent_Employee_Id from agents_details where Agent_Employee_Id=any(select Emp_Id from employee_status where Emp_acc_Stat='OPEN') ) "

need Agent_Id,Emp_Name in 1 table

Ya i've gone through this...and wrote like this...
<pre>MySqlDataAdapter da = new MySqlDataAdapter();
connection = new MySqlConnection();
dbconeector = new DataConnector();
ds11 = new DataSet();
DataSet ds12 = new DataSet();
DataSet ds13 = new DataSet();

//load agent info
ds11.Clear();
connection = dbconeector.connect();
MySqlCommand cmd1 = new MySqlCommand();
cmd1 = connection.CreateCommand();
string qyery1 = "select agents_details.Agent_Employee_Id,agents_details.Agent_Id from agents_details where Agent_Employee_Id=any(select Emp_Id from employee_status where Emp_acc_Stat='OPEN') ";
cmd1.CommandText = qyery1;
da.SelectCommand = cmd1;
MySqlCommandBuilder cb1 = new MySqlCommandBuilder(da);
da.Fill(ds11, "agents_details");
//MessageBox.Show("filled agents id table to dataset");
qyery1 = "select Employee_Id,Emp_Name,Emp_Mname,Emp_Lname from employee_details where Employee_Id=any(select agents_details.Agent_Employee_Id from agents_details where Agent_Employee_Id=any(select Emp_Id from employee_status where Emp_acc_Stat='OPEN') ) ";
cmd1.CommandText = qyery1;
da.SelectCommand = cmd1;
MySqlCommandBuilder cb2 = new MySqlCommandBuilder(da);
da.Fill(ds12, "agents_name");
//MessageBox.Show("filled agents name table to dataset");
dbconeector.close();
dataGridView1.DataSource = ds11.Tables[0];
dataGridView2.DataSource = ds12.Tables[0];


DataTable dt1 = new DataTable("table1");
DataTable dt2 = new DataTable("table2");
dt1 = ds11.Tables["agents_details"];
dt1.PrimaryKey = new DataColumn[] { dt1.Columns["Agent_Id"] };
dt2 = ds12.Tables["agents_name"];
dt2.PrimaryKey = new DataColumn[] { dt2.Columns["Employee_Id"] };
ds13.Tables.Add(dt1);
ds13.Tables.Add(dt2);
DataRelation drel = new DataRelation("EquiJoin", dt2.Columns["Employee_Id"], dt1.Columns["Agent_Employee_Id"]);
ds11.Relations.Add(drel);
DataTable jt = new DataTable("joinedtable");
jt.Columns.Add("Agent_Id", typeof(Int32));
jt.Columns.Add("Agent_Emp_Id", typeof(Int32));
jt.Columns.Add("Emp_Name", typeof(string));
jt.Columns.Add("Emp_Mname", typeof(string));
jt.Columns.Add("Emp_Lname", typeof(string));
ds13.Tables.Add(jt);
foreach (DataRow dr in ds11.Tables["Table1"].Rows)
{
DataRow parent = dr.GetParentRow("EquiJoin");
DataRow current = jt.NewRow();
for (int h = 0; h < ds.Tables["Table1"].Columns.Count; h++)
{
current[h] = dr[h];
jt.Rows.Add(current);
}
}
dataGridView3.DataSource = ds13.Tables["joinedtable"];
}</pre>

it shows error like this...

ds13.Tables.Add(dt1);"Datatable already belongs to another dataset

ok..That's working perfectly..Thanx very much

can't we write like this?
if (o== System.DBNull)
{
///
}

What is the difference between command timeout and connection time out?

Ya i'm having indexing in tables....Can u help me in how to set the timeout higher? is there any future prob with increasing that?

this size is in bytes?

Actually needs to show the internet status in apllication, always...

Hmm..i've read delegates..but now need some idea how to implement in my code..For my above prob that i want to show an progressbar/image while the connection to database completes which is happening through the Dataconnector Class..So as said above i need to add 2 events to this class and which will be raised with backgroundworker..then in calling form i'll respond to those events...

can u just help me in how add an event to my DataConnector Class? i mean where to declare its delegate?

Actually i'm very new in this dotnet...So i don't understand the the concepts u r reffering to..

Actually whenever i'm using more than commands to be executed on database, for each execution i'm opening connection and closing again...Is it advisible to connect once and execute as many no of commands and finally close the connection...I'm quite new in this field,any suggestion on this..

Hmm, in case of 56Kbps internet it's taking 3 secs..