Comments by John Mark Olesco

John Mark Olesco 13-Nov-13 2:35am View

I need MSSQL inorder for me to connect in sql azure. that's the reason behind using the mssql.
can you help me?

John Mark Olesco 12-Nov-13 4:11am View

Are you blind dude!? read my question first before posting any comment. Your not helpful but just a some sort of scumbag.

John Mark Olesco 3-May-13 20:07pm View

Thanks for the solution .but still it doesnt work.. I am pretty sure that the problem is in my query the way i handle the Aggregate function.. As what i've read rule "he projected columns in the SELECT statement may not contain aggregate expressions unless the statement uses a GROUP BY expression. When a GROUP BY expression is provided, the select list may contain the aggregate functions COUNT_BIG() or SUM(). However, SUM() may not be specified for a nullable column. The statement may not specify HAVING, CUBE, or ROLLUP" .. (Here is the link http://dimarzionist.wordpress.com/2009/04/01/how-to-make-sql-server-notifications-work/)
i think i violated the no. 5 statement in query notification..

I just don't know how to resolved it.. please help me..

John Mark Olesco 3-May-13 20:07pm View

Thanks for the solution.. I insist. the problem is in my query..
I knew that i did not or i havent followed one of the rule in query notification in this link (http://dimarzionist.wordpress.com/2009/04/01/how-to-make-sql-server-notifications-work/).. please help me..
it's all about in my query i just dont know how to solved it..

John Mark Olesco 8-Apr-13 11:11am View

hello Vani Kulkarni please help me with my problem..

John Mark Olesco 11-Mar-13 8:47am View

this is the code

String value = "";
String value1 = "";
String newvalues = "";
DataTable tbl = new DataTable();
tbl.Columns.Add("ID", typeof(String));
tbl.Columns.Add("PARENTID", typeof(String));
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT C.PRODUCT_CATEGORY AS CATEGORY, P.PRODUCT_NAME AS BRANDNAME FROM CATEGORY C INNER JOIN PRODUCT P ON C.PRODUCT_CATEGORY_ID = P.PRODUCT_CATEGORY_ID", con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
value = reader["CATEGORY"].ToString();
value1 = reader["BRANDNAME"].ToString();
newvalues = value;
//if (value !=newvalues)
//{
a++;
tbl.Rows.Add(new object[] { value, a });
tbl.Rows.Add(new object[] { value1, a });
//}
//else if(value.Equals(newvalues))
//{
// MessageBox.Show("Value Exist"+ value);
//}
}
return tbl;
con.Close();

John Mark Olesco 10-Mar-13 12:10pm View

As of the moment this is the code that i have..
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT C.PRODUCT_CATEGORY, P.PRODUCT_NAME FROM CATEGORY C INNER JOIN PRODUCT P ON C.PRODUCT_CATEGORY_ID = P.PRODUCT_CATEGORY_ID", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "CATEGORY, PRODUCT");
TreeListNode parentnode = treeList1.Nodes[0];
treeList1.DataSource = ds.Tables["CATEGORY, PRODUCT"];

John Mark Olesco 5-Mar-13 22:13pm View

it seems that the solution is not right..

my problem is how to solve the error of visual cobol named
"NO SQL DIRECTIVES HAVE BEEN SET"

how to get rid on that error?
and please tell me how to configure the connection string of database(ADO.NET) in visual cobol

John Mark Olesco 25-Nov-12 8:32am View

Haven't you tried creating an application that deals with an Clickable or Updateable Image ?

John Mark Olesco 25-Nov-12 4:02am View

Oh thank you for answering .. Another question is where could i find a dental chart that can be imported or attached into a Windows Form. I've already searched in google but really i couldnt find an exact or suited answer to my question.. Please I do reaaly need help.

John Mark Olesco 25-Nov-12 4:01am View

Oh thank you for answering .. Another question is where could i find a dental chart that can be imported or attached into a Windows Form.Ive already searched in google but really i couldnt find an exact or suited answer to my question.. Please I do reaaly need help.

Comments by John Mark Olesco (Top 11 by date)