I'm trying to figure out how to write this in LINQ.
Lets say I have a table of book reviews. Each book has a rating of 1 to 5. At the moment I am getting all book reviews by a bookID. I want to then say "Get the score that occurs most frequently for those given reviews". So if Book1 has reviews of 1, 1, 2, and 4, the statement would return 1. If Book1 has reviews of 1, 2, 2, 4, it would return 2.
I am counting from a table for that i have written code as below
protected void get_Id_Afterpoint()
{
int counter = 0;
string strSql = "select count(*) as ID from tblEnergy where ID=?";
OdbcCommand com = new OdbcCommand(strSql, con);
com.Parameters.AddWithValue("ID", DropDownList1.SelectedValue);
OdbcDataAdapter oda = new OdbcDataAdapter(com);
DataTable dt = new DataTable();
oda.Fill(dt);
if (dt.Rows.Count == 0)
{
lblID2.Text = "1";
}
else
{
counter = dt.Rows.Count;
counter = counter + 1;
lblID2.Text = Convert.ToString(counter);
}
}
there is no record related to DropDownList1.SelectedValue. but as i am counting if(dt.rows.count) and i put break point on the bolded part it shows 1 record. how it can be possible?
how can i select a record from A table and insert into B table using linq?
View 2 RepliesAm using Lucene.net 3.0 in my Application which as frequent updates to index.
But when new data on a forum it's not available in the search . it's taking few minutes to update index.
how can i overcome this.....
I made a function that sends emails to some members or subscribers , lets assume the email is a birthday greeting, if today is the member's birthday the system will send himher a greeting.The question is: How can I call or trigger this function everyday at a specific time automaticly !? The website uses .net Framework 3.5 & published on IIS6 .
View 2 RepliesI am using Table Adapter to insert records into my database. I first insert my member record into the database and it has no errors, after that i insert the contact records into the table. however I got the following error: You cannot add or change a record because a related record is required in table 'Member'.
[Code]....
I have a website hosted with sql 2008 database on Godaddy. Here's my problem descriptionbefore I actually begin implementing.Entries are made in a table named "XYZ" by a third party program. Now, there are multipleclients (could be asp.net ajax web based or vb.net desktop clients which I have not decided yet) who
read data from this "XYZ" table every 10-15 seconds. The connection string used by these clients would be same. If I have 10000-20000 clients making connections and querying same table, would that cause any breakdown? Since my connection string is same, connection pooling isautomatically in place.
What else do you think I need to take care of? Or is there any better way to implement this setup?Also, should I go for asp.net ajax client implementation or vb.net(c#) client implemtation ?Your inputs would be highly helpful to me. I am looking for a medium to long term solution to thissetup.
No records where inserted in my SQL Table after committing the transaction or after the .Flush() method. I checked the code and it follows the correct sequence of codes. I can't seem to find any other way where the error fails.
View 3 RepliesIs it possible to use LINQ to delete a row in a table within an SQL database? I am using an ADO connected command statement to delete a row where a string column equals a name. But, I would prefer to use an easier way with LINQ, if possible.
View 3 RepliesI've been playing around with MVC lately, and was wondering how you could do this:
I have a view that displays a list of products, and against each product is a list of categories (in a combobox). I'm trying to find out how you can update a product's category when you select a category in the list. I know you could do something fairly simple with jQuery, but I'm trying to understand how submitting forms works with MVC.
Here's what I currently have:
[Code]....
But I'm not sure how to tell the controller what product needs to be updated when the form is submitted.
I want to insert a new record into a table. The table has relationships with other secondary tables, For example:
Table: Stores
Table StoreCategories (a store can have many of these)
I want to insert a new store, get its ID and insert some categories in one go.
How do I go about this?
I have 3 tables(Roles,Actions and RoleActionLinks). Roles table has few columns(RoleID,RoleName,Desc). Actions table has few colums(ActionID,ActionName,Desc). In RoleActionLink is created for store the association between Roles and Actions and this table has the columns such as RoleID,ActionID When I created the data model(edmx). it shows only Role and Action as entity. i did not find RoleActionLink table. but even there is no direct relation between Roles and Actions table, both tables are automatically related using RoleActionLink table. When i create the new Action, a action record should be populated in Action table(this is works fine). At the same time, i need to populate record in RoleActionLinks table. But i dont have the entity to populate.
View 1 Replieshow to read last 20 record form a table for example (tb1) and the table consist of 3 column
View 4 RepliesI have a table that contain 1000 record and a webpage that contain 10 label to show the data in table and tow linkbutton for showing (next-previous) records. I want a query when i click on next show next 10 record and when i click on previous show previous 10 record (code in c# if possible)
View 3 RepliesI'm trying to put together a drop down list in asp.net from a query, I just wondered if I could go about it this way ( see code below). At the moment, ive got it to display the first record of the table in the drop down list. I would like to fill the drop down list with the whole of the recordset:
Code:
<%
Dim cnnSimple ' ADO connection
Dim rstSimple ' ADO recordset
Set cnnSimple = Server.CreateObject("ADODB.Connection")
[code]....
Do you think I could put a loop inside the option value = i bit?
i need to show for every refresh of page five categories, every time different how can i do? in SQL do not exist select RND(field)...
View 5 Repliesi made two table and their repectively sp
[code]....
nw firstly i insert all value which appears on Default.aspx page and then display on grid..
but primary i couldn't work insert that value then after display grid..
I have a SQL database that creates a record for every document uploaded by the user to the server. I want to check this table before a user uploads a document to ensure they don't upload a file with name that already exists.
I know how to make the connection and make the SqlCommand to query the table for an existing record. But I don't know how to check the record count from the sqlCommand I made.
Does that make sense?
Using myConnectionCheck As New SqlConnection(myConnectionStringCheck)
Dim myCommandCheck As New SqlCommand()
myCommandCheck.Connection = myConnectionCheck
myCommandCheck.CommandText = "SELECT * FROM Req_Docs WHERE Doc_Name =" & DocName
myConnectionCheck.Open()
myCommandCheck.ExecuteNonQuery()
End Using
I'm using SQL Server 2005 in a project, and i need to duplicate a record from a table and all it's relationships.
View 9 RepliesIn oracle we can do this by using rowid.
select * from tableName where rowid = (select max(rowid) from tableName);
but i don't know equivalent of rowid in sql server.
I have website database with a data table constently being "insert, select, count". This table has over a million record and is growing really fast.
Now I'm start worring about whether or not my sql server could handle the pressure. or maybe to have a million record is not a good practice at all.
The specs of my server is almost the best in the market. So I won't worry about the hardware.
Just wondering if ended up 3 million record in that table, will my queries and sql server itself still running smoothly?
Is there a function that will search a record in a Sql Table, I'm using VB.Net.
View 3 RepliesI would like to be able to send an email notification if a website user inserts a new record in a table. This will be a relatively rare occurrence so it would be very useful to have the notification as opposed to having my users check my summary page that lists all the IDs that have a record in this table. I googled but I must not be hitting on the right keywords or phrase to find the answer to this question. 1) letting me know if this is possible (I'm version ASP.NET 2.0 and using VB with a SQL Server database) and/or 2) pointing me in the right direction to find out how to do it if it is possible.
View 6 RepliesI'm not sure if I'm using the correct SQL for what I need. Well, I know that I am not because I'm not getting the results that I expect.
I have a table of products and it has a productID field and a setID field.
Products can be grouped together by making the groupID the same for the both of them.
I have only @productID parameter. My goal is to get a list of products minus this product and any other product that it is grouped with (ie..setID is the same).
Here is the query that I wrote because it has worked when excluding products from another table. I used the explicit GUID and still nothing.
[Code]....
I have to retreive all records from a table except 1 record. For example: I give example from default database in SQL ie "master" In "master" DB we have "spt_values" table. Now if I want to retreive all records from spt_values table except 1-1 record of type = A and type = B. To retreive all records its a simple query "Select * from spt_values where type in ('A','B')" -- this will returns 16 records. Now I want to retreive all record except 1-1 record left in each type, so it will return 14 records in result.
View 6 Replies