Comments by Adersh Ram

Adersh Ram 10-Feb-14 13:47pm View

I apologies you for my confusing question.

Yes, my plan is converting the query from the execution plan xml data. I couldn't find any other way to do that.

Is there any other better way to do this conversion?

Thank,
Ram

Adersh Ram 10-Feb-14 12:45pm View

Hi Dave,

Thanks for your response.

Yes i know. I can open the file in a Text editor.....

Actually i am working on a Custom Tool that converts the SQL query with different syntax for another Application. Please look below sample query.

SELECT @SELECT:Employee.ID:ID@,
@SELECT:Employee.LAST_NAME:LAST_NAME@
FROM Employee
WHERE
@WHERE:SECURITY:RESOURCE:Employee.ID@ = 1

The tool convert a SQL query like above syntax. Need to extract the sql query, to know the Columns, table, where conditions for generation above query. I was thinking about the execution plan xml file. I know all the table and conditions and select details available in the execution plans.

Whats your thoughts?

Thanks,
Ram

Adersh Ram 16-May-13 3:57am View

Thanks for your reply..

That means we wont make any changes in existing program, install directly into cloud server ?

Adersh Ram 5-Jan-13 5:11am View

Thanks Abhi

Adersh Ram 5-Jan-13 5:10am View

Thanks for share it

Adersh Ram 22-Nov-12 5:57am View

What is the actual problem ?

Adersh Ram 22-Nov-12 5:56am View

Then, why cant you do that ?

Adersh Ram 12-Nov-12 4:06am View

Hi,

I suggest add a new column in datagridview Like "Action", when editing a column
you change the Action column value to "Edit"(you can use Datagridview cellendedit event).

When inserting time you put a condition
IF (examinationlistrow.Cells["Action"].Value.ToString() == "Edit")
{

}

Adersh Ram 9-Nov-12 4:13am View

First you think what do you want to develop

Adersh Ram 9-Nov-12 3:57am View

Hi Ryan,
I resolved the issue.
Problem is loading an image logo to pdf page, so i just take image from a memmory stream.

Thanks for your reply.

Adersh Ram 30-Oct-12 2:33am View

Thanks All, these all links are helpful

I am trying to create a html with CSS and convert to pdf format, but the css part cannot implimenting on pdf.

ITextsharp dll is support the css class?

please help me.

Adersh Ram 18-Oct-12 7:47am View

I think report section is not "Detail" section.
Drag the objects to "Detail" section

Adersh Ram 18-Oct-12 7:37am View

Hi, this is not a clear question.
Say what exact you want to display

Adersh Ram 11-Oct-12 9:59am View

Hi,

You can get the new id from "SELECT @@IDENTITY", insert the data to grade table using this id.

Thanks
ARam

Adersh Ram 8-Oct-12 9:46am View

Hey,

Sorry for late reply !

Use:
rptdc.Setparameter("param name ","value");

I think it can help you.

Adersh Ram 8-Oct-12 9:34am View

Thanks Griff

Adersh Ram 4-Oct-12 6:58am View

Thanks, I am looking into your links .

Adersh Ram 2-Oct-12 15:17pm View

Thanks SA

It is really helpfull, sorry for late reply....!

Adersh Ram 2-Oct-12 7:57am View

ok, thanks for your quick reply.

Adersh Ram 2-Oct-12 7:51am View

sometimes it will change some condition, so it cannot hard code that....
Is there any way to do that

Adersh Ram 2-Oct-12 7:40am View

Creating the fist name spaces (second and third line )

Adersh Ram 16-Aug-12 9:20am View

Hi,
How did u set the report data source ?

Adersh Ram 4-Aug-12 1:32am View

Thank you so much _Amy. :)

Adersh Ram 18-May-12 5:20am View

Is your query is ok

Adersh Ram 6-Mar-12 6:19am View

what the error ?

Adersh Ram 25-Feb-12 4:19am View

can u explain

Adersh Ram 25-Feb-12 3:48am View

The best method is create a stored procedure for insert the data,and put the condition above, there is row exists in database it return the error message, else it is insert into the database.use normal executenonquery method
if any problem reply me

Comments by Adersh Ram (Top 27 by date)