Database

GuyThiebaut1-Dec-13 23:20

GuyThiebaut

1-Dec-13 23:20

mysql password protect database[^] Wink | ;)

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

Jassim Rahma2-Dec-13 22:30

Jassim Rahma

2-Dec-13 22:30

but this will protect the server!

What I want is to give my database a password so their administrator who'll access the same server won't be able to access my entire database even if he has a root for the same server because my database is password protected.

This option is available in Microsoft SQL Server and it's working great

Technology News @ www.JassimRahma.com

Richard Deeming3-Dec-13 1:36

Richard Deeming

3-Dec-13 1:36

Jassim Rahma wrote:
This option is available in Microsoft SQL Server and it's working great

Are you sure about that? Any administrator of the domain / local machine can easily give themselves unrestricted access[^] to a SQL instance, even if they're not set up as a user in SQL.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Windows Form BindingSource not saving changes in database

Eddy Vluggen3-Dec-13 7:12

Eddy Vluggen

3-Dec-13 7:12

Jassim Rahma wrote:
So what's your advise?

Webservices, and hosting the server yourself. Easy argumentation; you'll only be the database-admin if the server is yours.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Dean Henderson29-Nov-13 10:09

Dean Henderson

29-Nov-13 10:09

Update: This did turn out to be a pretty simple issue, so I am marking it now as an Answer. See the end of the message for the Answer...

I suspect I am making a very simple error, because I have a Windows Form application where I have added an Entity Framework DataSource bound to controls via a BindingSource/BindingNavigator that is not saving changes to the underlying SQL database.

I started by dragging the Entity Framework DataSource (as Details) onto a form.

This automatically created the form controls, the BindingSource and BindingNavigator.

When I first brought up the form, no records where being returned from the Entity Framework DataSource, so I created the following variable to initially load data that I was then able to view:

Private TblList As ObjectQuery(Of tblMyTableRec) = From tbl In ObjCntxt.tblMyTableRecs

Then I set the DataSource property of the appropriate BindingSource to this ObjectQuery:

MyBindingSource.DataSource = TblList

So far, so good ... The BindingNavigator now lets me move through the various records in the 'tblMyTableRecs' table.

But, when I make a modification of the data in any of the records (via one of the data bound controls), my changes are not being saved to the underlying SQL database the Entity Framework is setup to use.

I would greatly appreciate any suggestions about what steps I might need to take so that I am able to have changes saved in my SQL database.

Answer: The code generated for the Windows Form BindingSource and BindingNavigator do not automatically perform the Entity Framework ObjectContext SaveChanges operation. Once the SaveChanges function was executed in the Save button Event logic for the appropriate Entity Framework ObjectContext, the changes were saved to the SQL database.

Thanks, Dean

modified 5-Dec-13 21:18pm.

Reference

tsunamigang29-Nov-13 1:59

29-Nov-13 1:59

Hi friends. Can you tell me a perfect and simple website or book to know about the basic concept of OOPS in VB.net. Dont suggest simply google it. Specify some link or e-book.

Corporal Agarn29-Nov-13 2:06

Corporal Agarn

29-Nov-13 2:06

You do know you posted in the Database forum?

tsunamigang29-Nov-13 2:12

29-Nov-13 2:12

I do know.But I believed that there will be someone to help me.

Chris Quinn29-Nov-13 2:41

Chris Quinn

29-Nov-13 2:41

You don't think you would be more likely to receive relevant advice from the VB forum?

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Richard MacCutchan29-Nov-13 6:15

Richard MacCutchan

29-Nov-13 6:15

What do you mean by OOPS? Do you rather mean Object Oriented Programming? And why are you not willing to try a bit of Google searching for yourself? Especially as your question has nothing to do with Database. I would suggest reading http://www.codeproject.com/Messages/1278600/How-to-get-an-answer-to-your-question.aspx[^] before you do your Google searches.

Veni, vidi, abiit domum

http://code.msdn.microsoft.com/vstudio/site/search?f%5B0%5D.Type=VisualStudioVersion&f%5B0%5D.Value=10.0&f%5B0%5D.Text=Visual%20Studio%202010&f%5B1%5D.Type=ProgrammingLanguage&f%5B1%5D.Value=VB&f%5B1%5D.Text=VB.NET&f%5B2%5D.Type=Platform&f%5B2%5D.Value=Data&f%5B2%5D.Text=Data[^]

RedDk29-Nov-13 8:43

RedDk

29-Nov-13 8:43

how to find the return value of reader in mysql

Member 1026351928-Nov-13 1:20

Re: how to find the return value of reader in mysql

28-Nov-13 1:20

hi,
am selecting data from table . and executed reader with rdr=cmd.executereader()

based on the result i need to write the logic.
if( returns null)
{
}
else
{
}

Simon_Whale28-Nov-13 1:32

Simon_Whale

28-Nov-13 1:32

simple

if(rdr.HasRows == true)
{
  //do stuff
}
else
{
  //do no rows returned stuff
}

here is an example for you.

http://stackoverflow.com/questions/12609959/how-to-check-if-sqldatareader-has-no-rows[^]

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: how to find the return value of reader in mysql

Member 1026351928-Nov-13 1:51

Re: how to find the return value of reader in mysql

28-Nov-13 1:51

eventhough it's not working properly.
here is the code

string query1 = "SELECT tag_id,category_id,product_id,product_name,gate_id,remarks FROM transaction where tag_id Like '" + sEPC + "' AND out_time=NULL";
                                  MySqlCommand cmd1 = new MySqlCommand(query1, connection);
                                  MySqlDataReader rdr1 = cmd1.ExecuteReader();
                                 //int c = rdr1.RecordsAffected;
                                 // MessageBox.Show("count" + c);
                                  //if (rdr1 !=null && rdr1.Read() && rdr1.HasRows)
                                  if (rdr1.HasRows==true)
                                  {
                                      //ListViewItem item1 = new ListViewItem();
                                      item.SubItems[OUTTime.Index].Text = s2;
                                      //item.SubItems[5].Text = s2;
                                      //ListView1_EPC.Items.Add(item);
                                      //ListView1_EPC.Items[0].SubItems[OUTTime.Index].Text = s2;
                                      rdr1.Close();
                                      String s1 = "update transaction set out_time='" + s2 + "'  where tag_id='" + sEPC + "' ";
                                      MySqlCommand cmd2 = new MySqlCommand(s1, connection);
                                      cmd2.ExecuteNonQuery();


                                  }
                                  else
                                  {
                                      rdr1.Close();
                                      item.SubItems[INTime.Index].Text = s2;
                                      // ListView1_EPC.Items.Add(item);
                                      String a0 = ListView1_EPC.Items[0].Text;
                                      String a1 = item.SubItems[1].Text;
                                      String a2 = item.SubItems[2].Text;
                                      String a3 = item.SubItems[3].Text;
                                      String a4 = item.SubItems[4].Text;
                                      String a5 = item.SubItems[5].Text;

                                      String str = "insert into transaction(tag_id,category_id,product_id,product_name,gate_id,in_time,remarks)values('" + a0+ "','" + a1 + "','" + a2 + "','" + a3 + "','" + a4 + "','" +s2 + "' ,'"+a5+"')";
                                      MySqlCommand cmd2 = new MySqlCommand(str, connection);
                                      cmd2.ExecuteNonQuery();

                                  }

Simon_Whale28-Nov-13 1:57

Simon_Whale

28-Nov-13 1:57

Define not working properly?

also to read from the reader you have to do this

if(rdr1.HasRows == true)
{
 while (rdr1.Read())
 {
   //have made an assumption here that you have a ID field in the data
   //so that you can see how to get data back from the reader.
   int id = Convert.ToInt(rdr1["ID"]);
 }
}

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: how to find the return value of reader in mysql

Member 1026351928-Nov-13 17:52

Re: how to find the return value of reader in mysql

28-Nov-13 17:52

no i don't want to read the data of reader. datatype of out_time and in_time in mysql table is datetime.
my problem is:

1.select the data from transaction where tagid=? and outtime=null
2. if reader is having rows then write outtime into transaction table.
else
insert row into transaction table with only intime, no outtime

here is the code :

string query1 = "SELECT tag_id,category_id,product_id,product_name,gate_id,remarks FROM transaction where tag_id Like '" + sEPC + "' AND out_time=NULL";
                                   MySqlCommand cmd1 = new MySqlCommand(query1, connection);
                                   MySqlDataReader rdr1 = cmd1.ExecuteReader();

                                   if (rdr1.HasRows==true)
                                   {

                                   item.SubItems[OUTTime.Index].Text = s2;
                                rdr1.Close();
               String s1 = "update transaction set out_time='" + s2 + "'  where tag_id='" + sEPC + "' ";
                                       MySqlCommand cmd2 = new MySqlCommand(s1, connection);
                                       cmd2.ExecuteNonQuery();


                                   }
                                   else

                                   {
                                       rdr1.Close();
                                       item.SubItems[INTime.Index].Text = s2;

                                       String a0 = ListView1_EPC.Items[0].Text;
                                       String a1 = item.SubItems[1].Text;
                                       String a2 = item.SubItems[2].Text;
                                       String a3 = item.SubItems[3].Text;
                                       String a4 = item.SubItems[4].Text;
                                       String a5 = item.SubItems[5].Text;

                                       String str = "insert into transaction(tag_id,category_id,product_id,product_name,gate_id,in_time,remarks)values('" + a0+ "','" + a1 + "','" + a2 + "','" + a3 + "','" + a4 + "','" +s2 + "' ,'"+a5+"')";
                                       MySqlCommand cmd2 = new MySqlCommand(str, connection);
                                       cmd2.ExecuteNonQuery();

                                   }



                               }//if

here contains current date. everytime (even select command returns data ) it is executing else block only.is there any mistake in select query.

Member 1026351928-Nov-13 19:11

28-Nov-13 19:11

ok i got it. thanks for the help..

But now the problem is , i can have multiple records with same tag_id,
when i update all the records with same tag_id is updating.

i need to update only the latest record. how can i solve this.......

Cursors

tsunamigang27-Nov-13 18:40

27-Nov-13 18:40

Can SUM() Function be used inside cursors??
I used it but the code goes on executing. more than 10 minutes.
Why??

modified 28-Nov-13 2:03am.

Re: Cursors

GuyThiebaut27-Nov-13 21:41

GuyThiebaut

27-Nov-13 21:41

tsunamigang wrote:
Can SUM() Function be used inside cursors??

Yes.

tsunamigang wrote:
I used it but the code goes on executing. more than 10 minutes.

Why??

Show us yer code, then we may be able to help.
It sounds to me like you have not set up the condition on the cursor loop allowing the cursor to exit or you are not reading the next record from the cursor hence potentially leading to an endless loop.

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

modified 28-Nov-13 5:40am.

Re: Cursors

tsunamigang29-Nov-13 2:41