MySQL

Re: HELP Return String from SQL Statment & Increment this String

bhadhra — Sat, 18 Oct 2008 06:18:37 GMT

public string GetNewBranchID()
    {
        String sql = "SELECT max(last.branchNo FROM Branch ORDER BY branchNo";

        OleDbConnection connection = new OleDbConnection(GetConnString());
        OleDbCommand cmd = new OleDbCommand(sql, connection);

       OleDbConnection oConn = new OleDbConnection(sConn);
      oConn.Open();

      OleDbCommand oCmd = new OleDbCommand(sSQL, oConn);
      OleDbDataReader oReader = oCmd.ExecuteReader();

      while(oReader.Read())
      {
      int branchnor=int.parse(oReader[branchno].tostring()) +1;

string str=branchno.tostring();

}

}

Re: HELP Return String from SQL Statment & Increment this String

taketothesky — Wed, 08 Oct 2008 05:46:54 GMT

Can you give me examples? Of how to input into a string variable from a SQL statement and then how to manipulate a string variable via the substring? I can't find any examples out there. I can't find any examples on putting the value from the SQL statement into a string. And I have been trying to slice my value with the sql substr but I get a error Syntax error (missing operator) in query expression 'substr(TOP 1 branchNo,2,3)'.

So far nothing is going well for me tonight and I have spent hours trying to look this up!

I really appreciate any help you can offer with examples!!

Re: HELP Return String from SQL Statment & Increment this String

J K — Wed, 08 Oct 2008 05:17:44 GMT

Hi,
You can do this with simple srting manipulations in the same function
Regards,
JK

HELP Return String from SQL Statment & Increment this String

taketothesky — Wed, 08 Oct 2008 04:09:31 GMT

How can I get one value from a select statement and put it into a string and then modify it in that same method? What I want to do is get the last branch number and increment by 1 and return that value. It will be a string value so I will need to get help B002. So I would want it to assign B003 as my return value. Also, I have to use the OleDbConnection.

    public string GetNewBranchID()
    {
        String sql = "SELECT last.branchNo FROM Branch ORDER BY branchNo";

        OleDbConnection connection = new OleDbConnection(GetConnString());
        OleDbCommand cmd = new OleDbCommand(sql, connection);

       OleDbConnection oConn = new OleDbConnection(sConn);
      oConn.Open();

      OleDbCommand oCmd = new OleDbCommand(sSQL, oConn);
      OleDbDataReader oReader = oCmd.ExecuteReader();

      while(oReader.Read())
      {
        Console.WriteLine("{0}",
          oReader["branchNo"]);
      }

    }

MySQL

Re: ***HELP*** Return String from SQL Statment & Increment this String

Re: ***HELP*** Return String from SQL Statment & Increment this String

Re: ***HELP*** Return String from SQL Statment & Increment this String

***HELP*** Return String from SQL Statment & Increment this String

Re: HELP Return String from SQL Statment & Increment this String

Re: HELP Return String from SQL Statment & Increment this String

Re: HELP Return String from SQL Statment & Increment this String

HELP Return String from SQL Statment & Increment this String