|
More site info...
Data Access and ObjectDataSource Control | Forum profile
|
|
Forum profile page for Data Access and ObjectDataSource Control on http://www.asp.net.
This report page is the aggregated overview from a single forum: Data Access and ObjectDataSource Control, located on the Message Board at http://www.asp.net.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Data Access and ObjectDataSource Control" on the Message Board at http://www.asp.net is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Data Access and ObjectDataSource Control:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
106
|
441
|
1,190
|
|
Post:
|
231
|
841
|
2,586
|
|
|
Data Access and ObjectDataSource Control Posting activity graph:
|
Top authors during last week:
user's latest post:
Convert Ienumable into dataTable...
Published (2009-11-13 01:16:00)
Hi mailtosaja, Please try it like this: http://blogs.msdn.com/aconrad/archive/2007/09/07/science-project.aspx http://social.msdn.microsoft.com/forums/en-US/linqprojectgeneral/thread/35d44e33-ae9e-44f1-8254-9422de54d232/ Thanks.
user's latest post:
Cannot Find Table 0 - Fill...
Published (2009-11-14 04:05:14)
You need to look at the line like: dim sda as new sqldataadapter(" select GenderID,GenderName from Genders ",sqlconnectionobject) The message " Incorrect syntax near ')'." looks to be a TSQL error.
user's latest post:
select query on dataset
Published (2009-11-10 05:02:47)
Yes i tried ur solution but I a getting empty grid....... I mean there might atleast be something which could be done..... Thanks for ur reply......
user's latest post:
Cannot Find Table 0 - Fill...
Published (2009-11-13 11:30:13)
hello .TAD. , I have told that ( y ou will need the connection object and sqlcommand object to be assigned to sqldataadapter ) means the sqldataadapter also needs sqlcommand object and sqlconnection object just like you wrote in your function ListAllGenders dim sda as new sqldataadapter("select GenderID,GenderName from Genders",sqlconnectionobject) sda.fill(GendersDataset ,"Genders")...
user's latest post:
search text using vb.net / MS SQL
Published (2009-11-12 19:42:00)
Hi, For your scenarion you can use Full Text Search (FTS) in SQL Server. Where we have an option of seraching for a free text as you described. For more info you can refer to the MSDN @ http://support.microsoft.com/kb/916784
user's latest post:
select query on dataset
Published (2009-11-10 06:47:47)
The code I provide should work. I guess your data set is empty. Check it. If possible do this filtering in DB and pull the the filtered result. If not then you should store the data set in session first time and get the data set from session wherever you want. Get bck 4 ny clarifications. And paste ur complete page code.
user's latest post:
Passing NULL and NOT NULL as...
Published (2009-11-14 00:58:44)
You could do this.. SELECT ReadingDate, AvgCondensateTempF, AvgFeedWaterTempF FROM BoilersTestDataSupplyWaterAveragesPerDay WHERE (SystemID = 33) AND (ISNULL(AvgCondensateTempF, 0)...
user's latest post:
Cannot Find Table 0 - Fill...
Published (2009-11-14 03:49:13)
I fixed my previous error: In my Countries Table, I had 2 columns: CountryISO (PK) and CountryName. So I deleted the CountryISO column and added CountryID (PK) So now there is another error when I click submit: Incorrect syntax near ')'. But it doesnt show where. @tusharrs I did as you said, on my previous post.
user's latest post:
LINQ to SQL: How to test for...
Published (2009-11-12 13:11:00)
I have the following code: var blnProPhoto = from filePhoto in dcsPhotos.classNotesPhotos where filePhoto.photoID == Convert.ToInt32(hdfImageID.Value) select filePhoto.profilePhoto; if (blnProPhoto) { if (chbProfile.Checked) { //grab all the checked records var blnChecked = from myPhotos in dcsPhotos.classNotesPhotos where myPhotos.profilePhoto == true select myPhotos; foreach(classNotesPhoto myPhotos in blnChecked) { //set all the checked...
user's latest post:
Inserting Record - Catching...
Published (2009-11-12 10:43:00)
imchaz -- Regarding this... >>>Here is my code if this helps. I ...I think that I may see the issue... ...in your SendMailA() method, you catch and handle several excpetion cases... ...I think you cannot do it that way and I think the design needs to be changed to get the transaction to work the way you want... ...note that Rollback only occurs in the SendEmail() controller method and you have...
|
|
|
|
Latest active threads on Data Access and ObjectDataSource Control::
Started 3 days, 1 hour ago (2009-11-13 13:21:42)
by Rajneesh Verma
israelsapir: Hello: I want to update into the database ( sql server 2008 express) all the data that is added/updated/deleted in the my DataTable. How do I do that with the update command within the DataAdapter? (All the examples I looked in the were not understood and the MSDN also did not give a good example.) This is the code: DataTable table = DataBaseHelper.GetMyTable; // ...
Started 5 days, 2 hours ago (2009-11-11 12:03:03)
by TATWORTH
The lines Dim GroupsDataset As New DataSet GroupDropDownList. DataSource = GroupsDataset.Tables(0) While you have initialised GroupsData, but no tables have been added. To see this, try Dim GroupsDataset As New DataSet Dim tableCount As Integer GroupsDataset.Tables.Count
GroupDropDownList.DataSource = GroupsDataset.Tables(0) ' put debug stop on this line...
Started 2 days, 21 hours ago (2009-11-13 17:22:44)
by AZMatt
On the query that you are executing, you need to use the keyword " is " instead of "="...
SELECT a, b, c
FROM x
WHERE AvgFeedWaterTempF1 is @AvgFeedWaterTempF1
Then when you call the query, you pass "null" or "not null"...
e.InputParameters("AvgFeedWaterTempF1") = "null"
Started 2 days, 19 hours ago (2009-11-13 19:43:15)
by craigbtx
You could do this..
SELECT ReadingDate, AvgCondensateTempF, AvgFeedWaterTempF FROM BoilersTestDataSupplyWaterAveragesPerDay WHERE (SystemID = 33) AND (ISNULL(AvgCondensateTempF, 0) <> @CT) AND (ISNULL(AvgFeedWaterTempF, 0) <> @FW1)
ONLY one parameter can be 0 at a time. You can use 0 or any number the column is not equal too like 999999999 or -1.
the column with...
Started 2 days, 21 hours ago (2009-11-13 17:53:16)
by qarjami
Actually, I took care the null or 0 issue with Stored Proc. However, I have create an object for dataset. I am not able to see any records. are the my datatable syntax looks okay?
Started 3 days ago (2009-11-13 14:54:47)
by Rajneesh Verma
Hi, Try like this connection = "Data Source=MYPC\SQLEXPRESS;Initial Catalog=D.A.R.T.S.;Integrated Security=True"
Dim objConn As New SqlConnection(connection)
objConn.Open()
sql = "Select * From Employee Where employee_first_name = '" + fname.Text + "'"
daEmployee = New SqlDataAdapter(sql, connection)
Dim val As ...
|
|
Hot threads for last week on Data Access and ObjectDataSource Control::
Started 1 week, 1 day ago (2009-11-08 07:12:00)
by integrasol
Once you have the data in your DataSet, you can query it by using LINQ to DataSet, http://msdn.microsoft.com/en-us/library/bb386977.a spx .
Started 5 days, 2 hours ago (2009-11-11 12:03:03)
by TATWORTH
The lines Dim GroupsDataset As New DataSet GroupDropDownList. DataSource = GroupsDataset.Tables(0) While you have initialised GroupsData, but no tables have been added. To see this, try Dim GroupsDataset As New DataSet Dim tableCount As Integer GroupsDataset.Tables.Count
GroupDropDownList.DataSource = GroupsDataset.Tables(0) ' put debug stop on this line...
Started 5 days, 3 hours ago (2009-11-11 11:32:49)
by ScottR27
On a side note, you code is begging for a SQL injection... You should really be using SqlParameters for this see http://msdn.microsoft.com/en-us/library/system.dat a.sqlclient.sqlparameter.aspx . To answer your question, what are your data types for the Table? One of your data types is not matching, can you post the rest of the Stack? Hope this helps, --Scott...
Started 4 days, 22 hours ago (2009-11-11 16:02:11)
by mkamoski
I think one way to do it is to create and explicit transaction and assign it to the Command object...
...as noted here...
http://www.c-sharpcorner.com/UploadFile/dchoksi/tr ansaction02132007020042AM/transaction.aspx
...so I HTH...
Thank you.
-- Mark Kamoski
Started 3 days, 23 hours ago (2009-11-12 15:40:00)
by whatispunk
Rather than storing images in the db why not store all your images in one place. Keep only metadata in the database.
Started 2 weeks, 5 days ago (2009-10-28 04:04:00)
by suthish nair
please re-format and post again..
Started 5 days, 8 hours ago (2009-11-11 06:08:00)
by vipuldonga
hi, i think you can't write on the screen "strUpdate" string with parameter because they fill internally so when erver you print "strUpdate" thye only print you orignaly string.
Started 5 days, 6 hours ago (2009-11-11 08:31:00)
by anooj
Hi,
Plz refer these:-
http://bytes.com/topic/c-sharp/answers/785255-conv ert-ienumerable-datatable
http://www.chinhdo.com/20090402/convert-list-to-da tatable/
I hope this helps..
Enjoy..
Started 4 days, 4 hours ago (2009-11-12 10:55:00)
by hariram.p@live.in
The better is to use default.
DataSet dsDetails = default(DataSet);
but you have wrong returning way. You should have close any connection or something in finally
private DataTable test1() { DataSet dsDetails = default(DataSet); try { dsDetails = GetDetails();
return dsDetails.Tables[0]; }...
Started 1 week ago (2009-11-09 07:02:42)
by MetalAsp.Net
It depends how you're retuning the year. Are you doing a SELECT statement in your SP? If so, you want to use ExecuteScalar instead.
|
|
Size: 1,414 bytes
