look at the following code
[Code]....
The last three statments produces the same effect. Which one is better and mostly used?
I'm using the 'Configure Data Source' wizard to connect to my database and show the dataset in Gridview. I want to be able to update, insert and delete entries but am unsure how to build the query. I can write simple update statments to change database entries but how can I do this for entries that have been changed within the gridview?
View 6 RepliesI have a ListView bound to a database view (vw_Reunions). The Eval statements in the ItemTemplate render the data in vw_Reunions just fine but I have one in the LayoutTemplate that doesn't display. Can anyone tell me why?
[Code]....
This is my stored procedures with 3 selects statements
[Code]....
Now I have to fill two dropdown from the forst 2 select statements and need to fill some label through the 3 statement for this I did this
[Code]....
Its working fine my
[Code]....
Now I want to bind others controls. But I am not getting that how dataset differentiate which data need to bind to which control. How I can do this.
A bit new to buttonfields in gridviews - Did a bit of research and most of the stuff I came up with had the gridviews with data bound like so :
[Code]....
private void BindGridControl()
{//method created so that the binded gridview can allow paging controls
DataTable dt = new DataTable();
try
{
/*Gridview requires another column either a checkbox or a hyperlink column that
* can drill down another level and load a page where user can edit the data/cheque
* Will place an exception here that will prompt a window to notify users that
there were no rows returned
*/
GridView1.Visible = true;
sqlConn.Open();
sqlSearch = "select store_nbr as [Store number],date as Date,data_type as [Data type],acct_1 as [Account 1], ";
sqlSearch += "amt_1 as [Amount 1],acct_2 as [Account 2],amt_2 as [Amount 2], ";
sqlSearch += "acct_3 as [Account 3], amt_3 as [Amount 3], cheque_nbr as [Cheque Number], ";
sqlSearch += "cheque_amt as [Cheque Amount], gst_hst as [GST/HST], qst as [QST],comments as [Comment] ";
sqlSearch += "from SimpData where store_nbr = '" + StoreNum + "'";
sqlCmd = new SqlCommand(sqlSearch, sqlConn);
SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd);
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//if there are rows returned bind the datasource to the gridview
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
//label control notifies user that there are no rows found
lblResults.Text = "Search returned no rows";
}
My ButtonFields<Columns>
<asp:ButtonField ButtonType="Button" CommandName="Select" HeaderText="Select item"
ShowHeader="True" Text="Select1">
<ControlStyle Width="50px" />
<HeaderStyle Font-Size="XX-Small" />
</asp:ButtonField>
<asp:ButtonField ButtonType="Button" CommandName="Select" HeaderText="Select item"
ShowHeader="True" Text="Select2">
<ControlStyle Width="50px" />
<HeaderStyle Font-Size="XX-Small" />
</asp:ButtonField>
<asp:ButtonField ButtonType="Button" CommandName="Select" HeaderText="Select item "
ShowHeader="True" Text="Select3">
<ControlStyle Width="50px" />
<HeaderStyle Font-Size="XX-Small" />
</asp:ButtonField>
</Columns>
[Code]....
I want to set up a gridview that will display data like this
[Code]....
and that allows editing. Is it possible to have multiple update statements when editing from he gridview? Each day will need a separate update state since the data will be stored in the database like this
[Code]....
I think for each row I would need 7 update statements - one for each day. Is this possible with the gridview edit button?
I'm trying to add multiple statements to a onclick attribute of a Gridview row:[Code]. Something must be wrong with the way I concat the string 'script' with the statement that makes the row selectable. when the session var is null, then the Page.ClientScript statement goes through and the row will be selectable, but when the session var is NOT null and as a result, the whole statement contains the 'confirm' part, the the confirmation dialog pops up but nothing else happenes upon confirming. What's wrong with the "script += Page.ClientScript.GetPostBackEv..." part?
View 4 RepliesVS 2008 ASP.NET 3.5 app connecting to an MS SQL 2005 backend. The app contains a strongly typed dataset with a number of TableAdapters. I'm trying to add a query to one of the TableAdapters that deletes from table A, then related entries from table B, then related entries in the master table - table C. The query looks like this:
[Code]....
When I try to run that query to test it out, an error dialog box pops up that says "Unable to parse query text" followed by a second error dialog box that says "Must declare scalar variable @ID". Will the TableAdapters not run sequential Delete statements like this or did I do something wrong?
**Side note: A cascading Delete foriegn key relationship would be ideal, and was configured on the development database, but the DBAs messed up when replicating the database on the production server and getting them to fix something like this can be a difficult process.
I have a GridView with an TemplateField:
<asp:GridView runat="server" ID="gvReport" ondatabinding="gvReport_DataBinding">
<Columns>
<asp:TemplateField >
<ItemTemplate>
<asp:Label runat="server" Text='<%#Eval("answers") %>' /> out of <asp:Label runat="server" Text='<%#Eval("questions") %>' />
</ItemTemplate>
</asp:TemplateField >
</Columns>
</asp:GridView>
What I'd like to do on gvReport_DataBinding is change the field the Evals point to, so I end up with something like:
<asp:Label runat="server" Text='<%#Eval("answers_foo") %>' /> out of <asp:Label runat="server" Text='<%#Eval("questions_foo") %>' />
I have gotten this far:
TemplateField tf = ((TemplateField)gvReport.Columns[0]);
But I'm not sure what I should be doing with tf. tf.SomeProperty.Replace("answers", "answers_foo")?
Or am I barking up the wrong airplane on this one?
In my Admin page, I have a drop down list containing all current user tables in the database. The user chooses one.
My DetailsView below uses that parameter to populate itself with data from that table. The stored procedure used to select the data passes a string to sp_executesql. The string is concatenated from a select statement and the tablename parameter. Can I do something similar for Update/Delete statements? I'm not sure of the best approach, given that I won't know which/how many fields will be in the DetailsView at runtime, and which of these are keys - the choice of table depends on the user. I think Insert will be straightforward - am I right? I would like to streamline things as far as possible. Is it possible to dynamically pass in the values in, say, a string, and get my stored procedure to understand them? And what's the best method of grabbing the values from the DetailsView in this situation?
I need to write a select query where it will be doing "like" on one column with multiple strings.
Eg : Select * from tblCity where city like '%ABC%' and city like '%XYZ%'
I have set of strings.
[Code]....
I want to insert a record into a log table ONLY if one exact copy already doesn't exist within ten days, what is a good way to do in one stored procedure what I do above in two?
I tried to find a LINQ section on this forum, but couldn't, so I'll post this here since is deals with LINQ, C#, MVC, SQL Server, and well...just about everything.
Here's the details....My Application is an ASP .Net MVC 1.0 app, using C# 3.5, SQL Server 2005 Std, and LINQ to Entity.
In my View, I have numerous Html.CheckBox controls, they get passed to my Controller as a string collection via a JQuery Ajax call. The values of each checkbox are seperated by a comma(,). I then Split the string, to get the individual values. The overall purpose to to allow users to build a custom report with only the data elements they have checked the boxes for. Here is my controller:
[Code]....
The part that I am having a problem with is that I only want to Insert the data elements into my DB table for the ones that the user has selected the checkbox for. So, for example, I'd like to do something like this:
[Code]....
I don't know if there is a LINQ switch statement in which I can access outside variables and the columns of the table, or any thing like that.
This is the code i have used to get LocationID from database with MerchantID. I am getting an exception from Fill dataset part. The error is Error converting data type varchar to bigint.
public DataSet getLocationID(long MerchantID)
{
//long LOCID = null;
try
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@merchantID",MerchantID)
};
string strCommandText = "Select LocationID from Merchant_Location where MerchantID ='@merchantID' order by LocationID ASC";
Debug.WriteLine(strCommandText);
DataSet pds = new DataSet();
SqlHelper.FillDataset(DbConnString, System.Data.CommandType.Text, strCommandText, pds, new string[] { "LocID" }, parameters);
return pds;
}
catch (Exception ex)
{
//LogError("Error Occurred When Retrieving LocationID: " + MerchantID.ToString(), ex);
return null;
}
}
Is it possible to add multiple select statements in a single stored procedure. The select statements are getting data from different tables. If yes, could anybody provide an example in adding multiple select statements, which retrieve data from different tables in a stored procedure.
View 3 RepliesI have a stored procedure which is part of the aspnetdb but i am using my own database and therefore these stored procedures are added on my sql server locally.So i uploaded the databases to my hosting company 1and1 and created the stored procedures and tables as those in aspnetdb but i get the error as in the title. this is a standard stored procedure which lives in the aspnetdb database but not sure why this is happeningthe code is below which is for aspnet membership createuser a standard stored procedure
[Code]....
I have a BasePage class that all of my content pages inherit from. In my BasePage, I have many Import Statements. It seems as though they carry over into the derived class as one would expect. However, if you were to try and access code in the client aspx design page, as you would in the code-behind, you run into problems.
For instance, in my BasePage i have a Public Enum named ThemedSites. It's just an enumerator that lists the 5 different themes my site could be skinned as. I, at times, need to do different things in code, and in design, depending on what theme I'm currently in. I have a Public Property named CurrentSite (might have been more appropriate to say CurrentTheme, but that's besides the point). CurrentSite's return type is ThemedSites. So in code, one would say something like:
[Code]....
This works great in any page that inherits the BasePage class. This falters when that very same logic is used in the design page like:
[Code]....
Now, it works if you fully qualify both sides of the condition, but that's not my question. My question is: why isn't the Imported NameSpace in the BasePage recognized in the client-side server tag, as one would think it would be, according to how it IS recognized in the server-side code-behind?
I would like to manipulate and get the result the following statements dynamically. I have string value in followinf format.
[Code]...
I am trying to insert data into two table at the same time , but i'm successding in inserting data into only one table at a time on button click .
[Code]....
When i run the code, data gets inserted into table "implantDetails" only. Are multiple INSERT statments allowed?
string sqlstring =
"SELECT DISTINCT STAFF_ID, SCHOOL_CODE FROM MODULE_TIMETABLE_STAFF WHERE STAFF_ID != '" +userId +
"' AND STAFF_ID LIKE '%" + Searcht +
"%' ORDER BY STAFF_ID ASC";
can anyone explain this statement for me? especiallythese signs !=,+ +
I want to add Sum contents from the two tables, Realize the rows could be different, Only like rows to be added rest of the rows from both tables are listed.
SELECT TYPE AS CashFlow, Sum(AceData.InCredit) AS Credit, Sum(AceData.OutDebit) AS Debit, Sum([InCredit]+[OutDebit]) AS Totals
FROM AceData
where case=1
GROUP BY Type;
CashFlow Credit Debit Totals
Advert $0.00 ($5,816.52) ($5,816.52)
BOND $0.00 ($3,060.00) ($3,060.00)
Cash $18,619.57 ($34,824.75) ($16,205.18)
Charity $0.00 ($6,578.00) ($6,578.00)
DayCare $0.00 ($2,360.00) ($2,360.00)
SELECT TYPE AS CashFlow, Sum(AceData.InCredit) AS Credit, Sum(AceData.OutDebit) AS Debit, Sum([InCredit]+[OutDebit]) AS Totals
FROM AceData
where case=2
GROUP BY Type;
CashFlow Credit Debit Totals
BOND $0.00 ($3,060.00) ($3,060.00)
Cash $18,619.57 ($34,824.75) ($16,205.18)
Charity $0.00 ($6,578.00) ($6,578.00)
DayCare $0.00 ($2,360.00) ($2,360.00)
Entertainmen $0.00 ($12,258.18) ($12,258.18)
Equipment $0.00 ($7,085.00) ($7,085.00)
Fee $1,957.63 ($27,611.85) ($25,654.22)
How can I schedule several statements that involve select ... into ..., delete, and exec one other stored proc, periodically? For instance, every 6 hours, in Sql server DB
View 1 Repliesi want to execute more than one query in a page.i tried to use sqlreader it didnt allow me to include.how to do ?This is my code.
[Code]....
this is how i did.it shows me error.how to solve this error?
I'm using MySql in my asp.net project. But I don't want to type every "using MySql.Data.MySqlClient;" statement in every aspx.cs/aspx.vb file. How can I define this lines in web.config file?
I've defined some namespaces like below but this only works for aspx pages:
<?xml version="1.0"?>
<configuration>
<system.web>
<compilation debug="false" targetFramework="4.0"/>
<pages>
<namespaces>
<add namespace="System.Web.Configuration"/>
<add namespace="MySql.Data"/>
<add namespace="MySql.Data.MySqlClient"/>
</namespaces>
</pages>
</system.web>
</configuration>
related question : Define common namespaces for code pages in Web.Config
Is there any difference between below two statements
if (null != obj)
and
if (obj != null)
Edit: if both treated same which will be preferable?