|
Pius__X wrote: I am using database which content are more than 100 000 rows.
That's not large. The database I'm working on at the moment grows at a rate of around a million rows per week.
Pius__X wrote: Is posible using open conection in .Net and read only rows what I just need to view alike in VB 6?
Since I've never used VB6 I can't answer that exact question. However, If you want to get data out and processing as it arrives rather than wait for the whole set to arrive first then you need a Data Reader. It provides a fast, forward only view of the data.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
DataReader is fast, but how to bind DataReader with DataGrid?
Because bind DataReader with DataGrid manually is too compliacetd.. may be not possible.....
manually - I thing, read rows which should be currently view in DataGrid.... not all rows which content database and when you scroll DataGrid then read next rows..... OH MY WEAK ENGLISH
Colin Angus Mackay <-- "million rows per week" are you using DataGrid for viewing these to many rows?
thx
|
|
|
|
|
Pius__X wrote: "million rows per week" are you using DataGrid for viewing these to many rows?
Good grief, No!  I was just suggesting a new perspective on what you think of as a large database. In fact, SQL Server 2005 Enterprise Edition can handle a database that is up to a billion terrabytes in size. (Remember that SQL Server can handle many databases also)
Pius__X wrote: DataReader is fast, but how to bind DataReader with DataGrid?
If you must use a data grid then you have some other solutions. For example: Populate the data grid with less data. This is common, but requires extra work if you don't want the user to notice. However, normally, there would be page forward/backward buttons for the user to scroll through the data.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
Is it posible access to database whitout DataSet and DateReader and use open connectivity or there are only thease two ability?
Or how to set DataGrid to view data which sould be currently view in DataGrid, here is example.....
I have DataGrid where are show 10 rows, without using scroll bars, when I scroll down next 10 rows then some object read next 10 rows from databaze and show them to DataGrid... How to do this things in .NET?????
thx
|
|
|
|
|
can anybody tell me how i can connect vb.net with mysql.
byeeeee
Aavesh
|
|
|
|
|
Have you looked at mysql's website?
|
|
|
|
|
hi
i went on the mysql website.but i'm very novice in dotnet.so didn't get anything please send me the code or steps to connect.
Aavesh
|
|
|
|
|
Access MySQL from NET application can be done as same as MS SQL Server by using MySQL Connector for Net. Just download that connector from MySql website and see their samples enclosed.
|
|
|
|
|
|
hi
plz can u help me
I make the data base employee form
this form company
i but all information in the data base and make in vb form to make a small project
i went to help and give the code for use a search button
to search in the data base and give me the information for the employee who`s i wont to search it
and thanks or ur help
|
|
|
|
|
hi, I have a dataset, DataSet1, populated from a database table named "Sections" which is bounded to DataGrid1.
I want to remove a row if a user selects it in the datagrid and presses the remove button. here is the vb-code:
Private Sub cmdRemove_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRemove.Click
If DataGrid1.CurrentRowIndex >= 0 Then
DataSet1.Tables("Sections").Rows.Remove(DataSet1.Tables("Sections").Rows(DataGrid1.CurrentRowIndex))
MessageBox.Show(DataSet1.HasChanges)
OleDbDataAdapterSections.Update(DataSet1, "Sections")
DataSet1.AcceptChanges()
End If
End Sub
But messagebox shows False, and the row is not actually removed from the database, ALTHOUGH DataGrid1 shows that the row has removed from dataset!
(I use the same method i.e. DataSet1...Rows.Add(..) and then the oleDbDataAdapterSections.Update(..) to add rows which works perfectly!! But the added rows are not removed using the same code from the database...)
I really dunno the reason and got confused!
-- modified at 17:50 Friday 31st March, 2006
|
|
|
|
|
i want to company that if today date is greater than do step 1 and if not than do step 2 and i m doing this
IF dbo.FormatDate(GETDATE()) > dbo.FormatDate('28/04/2006')
--Step 1
ELSE
--Step 1
but its not proper working i can do this with year, month and day individual comparison buts not proper way to acheive task.
can anyone tell me that what's the mistake in above code
dbo.FormatDate() is a function which extract only date from date and time.
Thanks
|
|
|
|
|
I'm guessing (becuase you've not provided the code) that FormatDate is a UDF that returns some value that you can test against. I don't know why you need to do this as you can check greater than/less than on a date already.
IF GETDATE() > '2006-04-28'
BEGIN
-- Do stuff
END
ELSE
BEGIN
-- Do other stuff
END
I would recommend that you always use ISO dates (YYYY-MM-DD) - that way you don't get messed around with cultural specific problems.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
Thanks for ur comments i have solved the problem with this code
SET Dateformat dmy
IF GETDATE() > dbo.FormatDate('24/04/2006')
BEGIN
PRINT 'A'
END
ELSE
BEGIN
PRINT 'B'
END
Thanks
Best Regards,
Tariq Mahmood
|
|
|
|
|
Hello
I'm trying to connect to SQL Server2000 that in another computer in local area network.
but it says login failed for user "Guest"
- I added my windows account (MyDomain\MyWindowsUserName) to SQL Server.
- I use windows only authentication.
- both computers are Windows XP Pro-service pack 2
- When I add Guest windows user to SQL server, it works fine.. But I don't want to use Guest account.
- both computers are in same WorkGroup
- I added user name to server computer with exactly same user name and password.
any help... thanks
|
|
|
|
|
denizmercan wrote: I added user name to server computer with exactly same user name and password.
Have u added username in Sqlserver Database Users?
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
Yes I added.. and I gave full permission to that user.
|
|
|
|
|
I am asking whether u have added user name in enterprize manger users
ie database users
Got me
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
Yes I did what you say...
|
|
|
|
|
Hi there,
I am installating msde with my application using installshield (10.5) prerequsites(redistributable). The problem i have is that on windows 2000 after msde installation system require a reboot(there is no way out i tried all the commandline arguments but even if i am sucessfull in supressing reboot still sql script with my installation which create database don't get sucessful without reboot). To solve this problem what i tried is to use installscript and add a registryentry in runonce as my installation begins and delete it at the end of installation with another installscript custom action. The only problem is that i can't run my custom action prior to setup prerequisites get installed. I tried to set the sequence of my custom action to -5(means run first up) but still the msde setup starts prior to my custom action. Is there a way to run custom action prior to setup prerquesites or is there any solution to continue setup after msde installation?
Thanx for help in advance.
Qaiser.
|
|
|
|
|
Hi,
I need help on creating an SQL statement that will add up all the numbers in a given column of all the matching rows of data.
At present i have:
OleDbCommand cmdC = new OleDbCommand("SELECT COUNT (bookingNumbers) FROM tbl_Booking WHERE bookingWhen='"+addDays+"'", myConnection);<br />
cmdC.Connection.Open();<br />
covers = Convert.ToInt16(cmdC.ExecuteScalar());<br />
cmdC.Connection.Close();
But this just returns the number of matching records rather than the total of the data in these records.
Any help would be greatly appreciated!
Thanks!
Pablo
|
|
|
|
|
The SQL COUNT function returns only a count of records returned. You need to use SUM instead but you will be forced to use GROUP BY since SUM is a summerization function.
|
|
|
|
|
Hi,
Thanks for the reply.
Im new to .Net so could you give me an example of how to create this statement, and if possible how to run this code in c# .Net ?
Thanks!!!!!!
|
|
|
|
|
First of all, your problem is really SQL related. I am getting ready to go to work and I don't have time to leave a good example so here is how your SQL might look like:
SELECT SUM(bookingNumbers) FROM tbl_Booking WHERE bookingWhen='"+addDays+"'"
The "GROUP BY" might not be necessary. If it is do this:
SELECT SUM(bookingNumbers) FROM tbl_Booking WHERE bookingWhen='"+addDays+"' GROUP BY booingwhen"
|
|
|
|
|
what is a Tenant Database?
Mad Max
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
