Posts by Ramy Mahrous

the problem is in datRead.GetString(X) you says give me string, he (VS) replies I don't have string, I've Int32 what shall I do for you.
Check the data types in your table if you have column of Int32 use GetInt32(X) or if you've column of bit use GetBoolean(X)

Hope it solve.

You can't give dynamic statement as it's your logic exception, the method calls this method (which contains this switch...case) will handle this throw with meaningful error message to the user.
I really don't understand your question, give a scenario.

right click on table then open table, write data row by row
or you can add data from application using ADO.NET

use SQL CLR to add your logic :)

Please mark it as solved then :)

You can create your viewer to text files by using control like RichTextBox and use .LoadFile method which takes text file path
Or
Using default text file editor on client machine by call Process.Start(filePath);

You can use replication or use SSIS to move the data (formerly know DTS)

What's the error shown in error window?

Look I tried it myself, it works
I dragged and dropped a DataGridView control, I binded it a datasource, then I dragged and dropped a Button, on its ClickEvent handler I wrote this code

dataGridView1.Columns[2].Visible = false;

It removes this column == it works.
Or I don't understand you.

Using iTextSharp

iTextSharp is a .NET port of iText, a PDF manipulation library for Java. It is primarily focused on creating and not reading PDFs but there are some classes that allow you to read PDF - especially PdfReader. But extracting the text from the hierarchy of objects is not an easy task (PDF is not a simple format, the PDF Reference is 7 MB - compressed - PDF file). I was able to get to PdfArray, PdfBoolean, PdfDictionary and other objects but after some hours of trying to resolve PdfIndirectReference I gave up and threw away the iTextSharp based parser.
More on: http://www.codeproject.com/KB/string/pdf2text.aspx

P.S: I used it personally, it's really good library

There are commercial version from Crystal Reports from Business Objects you can check the features of what you have and what they buy through http://www.sap.com/solutions/sapbusinessobjects/sme/reporting/crystalreports/index.epx

As you need it in VBA you should ask this question there http://www.daniweb.com/forums/forum4.html

Is it database design problem or VB.NET one?
Please mention your db design to help you out how to solve it

Hope it helps http://www.codeproject.com/KB/string/pdf2text.aspx

dataGridView1.Columns["column name\ index"].Visible = true\false;

loool you didn't :)

ToUpper method, you can use it to convert character to capital.

You're welcome :) I'm happy you solved it but I don't understand your note!!

See that it may help http://geekswithblogs.net/mtreadwell/archive/2004/06/06/6123.aspx

Look again, in BindingNavigator controls (buttons) modify its modifier access to public, sure you didn't if you did, you'd see them when access this user control

Give me your code "that loops for threads and kills them"

Sure, feel free to ask :)

I've answered you at C# forums, right :) ?

Design it in the report, else you've parameter you can pass its value at runtime using SetParameters(List<ReportParameter>) method.

Terminate the thread once it finishes its work, don't wait to loop on the threads and Kill them...

You need to make the grid movable, because of being a control you can take a look at http://fci-h.blogspot.com/2008/05/how-to-make-your-controls-moveable.html and add modify it to be applied on run time controls

Due to accessibility to controls event handler, you can modify it to public.

I got this solution too but for some reasons I preferred server side, yes Java Script would be better, Thank you Aneesh_Argent so much :)

I want to speed ChechBoxList's getting the selected items, the normal approach is

foreach (ListItem li in checkListBox.Items)
{
if (li.Selected)
{
}
}

but if I've 6000 items in the CheckListBox, that's mean I should go through the 6000 items to know which is selected. Performance POOOOOOR!!!
Is there way to get just selected ItemsCollection ??

All in all it's control, and any control has Anchor property which helps you resize the control corresponding to form size.

Read about ADO.NET in http://msdn.com

@Danny: Don't say that man, I am your student I'm not blushing to say that, I consider you from experts I learn from, thanks man :)
But here I just misunderstand you :$

@Jerry: Hey, my friend, I too miss you really, keep in touch :)

Danny :) he said

im trying to captilize the first word of a line

not the first character!

You can split line by ' ' space, get words[0] -first word- capitalize it, then return this array to 1 string again.

Your logic is wrong! you should have Sql statement which takes 2 parameters username and password and returns scalar value number, 1 is valid or 0 otherwise, don't select from DataReader!!

http://support.microsoft.com/kb/139444

1- I don't know really what happen if .NET SQLTransaction rolls back, but you can also develop a trigger to keep track on deleted items from Father, Mother, Brother tables. (I think this solution is a bit nice)
2- You can have a temp table in your database called current user, holds the user currently run the application and then whenever your trigger triggered get the value from this table.
P.S I expect just one user running this application, tell me more about that. To get optimal solution.

Please drop here the error you got.

It depends on how you display text in your made browser!! you can increase text in the page with value whenever user press the button.

Very good bcasp :) they answer the question. You need to read in where clause SELECT column1, column2, .... FROM TABLE WHERE column4 = @value1 AND column5 = @value2

Is there an easy way to tell the trigger: If the action which causes you is rolled back -> role back you action?

I think you determine that in the trigger you fire it after or before committing the action. read in triggers at MSDN.com

second issue you can pass any values to trigger rather you should maintain the DB design to save who does the transation

You've this table in your database, RS just run a query to get result displayed in the report, did you develop the query to get this result?

I don't understand your problem neither the error you got. Please clarify your question, copy the error message and tell us which language you use.

BegineInvoke takes to arguments and seems you send just one argument.
1- Send Method name without "( )"
2- If the method is parameterless pass empty array of object new object[] {}

Copy the exception raised...

It done by +1000 ways, I presented outline, you can ask in web-development forum.

Use Invoke, I think you don't consider Asynchrony to use BeginInvoke and EndInvoke..
I think you don't need an example to include your code in method!

Are you sure you using correct database?

You can create your method and enclose this code inside Image1.Left = Image1.Left + 1 then invoke it.

Go to Java forum!!