Posts by Ramy Mahrous

From your last reply I see something like that before at http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/7e5da9e1-3520-492c-bbe1-3516f0ccecaa/

Try to ask in Microsoft SQL Server forum there's may be a hotfix or trick..

What I need is to Display the data before showing(Show or ShowDialog) it...

We don't answer exams!!
But what I can do is to guide you to look at System.String and System.Text namespace...

OK, I don't need you to develop something with Integration service, red X because you're missing something (don't care about that right now) you didn't tell me. Does Service Agent work?
Second take a screen shot to the error, and attach it here.

Please explain more

Please mark both threads as solved, if it's :)

Thread subject has meaning and the content has another, I just answered what I thought they need..

It works my friend, I just put the answer here too because it's also related to VB.NET

Dim r As SqlClient.SqlDataReader
r = SQLComm.ExecuteReader()
dgCustomers.DataSource = r

It works fine

Dim r As SqlClient.SqlDataReader
r = SQLComm.ExecuteReader()
dgCustomers.DataSource = r

I'm sure you using SQL Server 2000
So, the error is you didn't give some permission to ASP.NET user who trying access SQL instance, therefore it blocked.
From server security in SQL Server Enterprise Manager, logins right click and add ASPNET user with windows authentication type.
Try running the application again then tell me what happened.

Ctr + F5 :)

If you traced the SQL Command sent, you'll find it doesn't surround the state within single quotes '
What you need is to modify it Dim SQLComm = New SqlCommand("SELECT * FROM ViewCustomers('" & vRegion & "')", conn)

If you traced the SQL Command sent, you'll find it doesn't surround the state within single quotes '
What you need is to modify it Dim SQLComm = New SqlCommand("SELECT * FROM ViewCustomers('" & vRegion & "')", conn)

In Microsoft Access you can't!

Integration services from Start->Microsoft SQL Server 2005->SQL Server Business Intelligence Development Studio try to create new Integration services project
To check Agent Service you'll find it in SQL Server Management Studio SQL Server Agent

From Form properties make Key preview property true, in case your answer to Lizr question is YES.

Catalog=Database your database called database?? Give us the error, to help you :)

For business applications (Database as backend) C# is better
For learning and teaching students what the programming is; C++ is better.

C# 3, .net 3.5

Integration services work fine? and check if Agent service running or not.

OOH, I thought it's like 2005, I suggest to search in SQL forums, I'm downloading it right now and I'll see...

Did you try?

myRtnValue = myUserControl.DisplayData()
Me.Show()
'Me.Hide()
 ....

Please, write the answer here to help others who face the same problem to find its solution.
Then mark it as solved.

Did you automate it?

Bob just spend 3 minutes discovering you'll learn more and more yourself, it's not that hard, if you didn't get what you need, drop a reply here.

I need some tips from you as skilled DBA or at least better than me at this field, what's your notices??

For example you need to enter "string" and it tells you the developer used this class or not.

separate Exhibition and Art tables, I think the relation should be many-to-many so you need to use bridge table

I want to know how to be :)

Search in Google "DataGrid + VB.NET"

Yes, I don't know how to answer your question, System.Net classes and nice windows application all you need to do it.

I am very thankful to your words, really you prove for me, there still long way I should cut to become really skilled DBA\BI\Software Engineer.
Your words is more valuable than any reply I got in my entire life really I don't overdo, it really is.
And it doesn't mean I've 1000+ posts and you've 50+; I am better than you. Absolutely NOT
I'll open a thread asking how to be skilled DBA, and I am deeply in need for your help.

Thanks, pclfw

Thanks for sharing :)

So, what do you think about my design?

Thanks for sharing

LOL, I got it, I don't know, they may understand my question wrong :D

That's simply because you don't write anything to the stream!!

Here you're

ab = RichTextBox1.Text.Replace("\n", "\r\n") ' to keep new lines in text file like richbox
Dim stringAsBytes() As Byte
stringAsBytes = New System.Text.ASCIIEncoding().GetBytes(ab)
myStream.Write(stringAsBytes, 0, stringAsBytes.Length)
myStream.Close()

You can work with MySQL as backend from .net application using their libraries on http://mysql.org

Very great question, DotNetNuke is an open source web application framework ideal for creating, deploying and managing interactive web, intranet, and extranet sites securely.
More on http://www.dotnetnuke.com/

Need concepts, designs, practices, Videos, communities and news about C# and XNA http://MSDN.com your way, I don't read single book in C#, I depend on classes documentations and MSDN.

You didn't normalize you DB design, you need to have table for Crane, Manager, Country, Region and Site.

I think your ERD fulfills your requirements but it's not clear, if you work with team to develop this application try to brainstorm the design of ERD

Did you install any version of reporting service before 2008? and this error comes when you configure reporting service or when you access it use internet browser?

What do you need to do kashyapanirudh??

To run as administrator

So, tell me the problem you face and when it raises!

Microsoft SQL Server 2008->Configuration Tools->Reporting Services Configuration

That's what I want to hear from you :) mark this thread as solved and write and hint it's impossible :)

These questions to me?