WHAT EXACTLY I WANT IS TO RETRIEVE DATA(may be from separate table) AND THEN DISPLAY THEM PUTTING SOME STYLE(font,color etc). Is retrieving from multiple table is possible in gridview ? I could use the DataReader, but how to display them in style(font,color etc)?
can i add string builder object to a dictionary object? If yes code it. I mean i have a dictionary in which i have already added a few (string, objects), and i have a string Builder which has few variable already added now i want that instead of passing 2 different object in a method i want to pass only one object so can i add string builder object to same method as well
the problem is if i do this i get a js error of Error: syntax error Source Code: return ShowContextMenu(event, StringBuilder sb = new StringBuilder(); sb.AppendLine("<b Id='"); sb.AppendLine(assets_item.Id.ToString()); sb.AppendLine("' oncontextmenu='return ShowContextMenu(event, "); sb.AppendLine("ctl00_ContentPlaceHolder1_rptNav_ctl00_AssetsTreeControl_1_pnlAssetsContext"); sb.AppendLine(")'>"); sb.AppendLine(assets_item.Title); sb.AppendLine("</b>");
I try to use method post to pass variable to next page. I find out that i can use stringbuilder to crete html element and then have the variable i want to pass in hiddenfield and then post and redirect to second page.
execute stringbuilder immediatley after a button is click ?
I'm creating a reports with the following filter criteria:
ID - textbox Created Date - range between start and end date Syste Name - dropdown Users may filter the report based on the ID or System Name or all the criteria mentioned.
The search Field for ID, by default has a Null checkbox beside on it while other filter doesn't. how can I enable the checkbox for the other filters?
So I came across this article which should my issue. Apparently, I'm receiving a formula error "The arguments to the following functions are not valid:FIND" with this formula OR(FIND(Creation Date, Parameter: Creation Date)<>0, Parameter : Creation Date = Empty). see this link for the screenshot. I don't know what I'm missing. I'm using Reporting Services 2005
I am using LINQ to SQL in my application. I have some fields like textbox and checkbox in my form. when i enter any text in textbox it should search the data in the database. it should display in some control. Here i want to write query in LINQ I want to use predicate builder. If we are using sql server we have to write in stored procedure but i dont want in stored procedure. plz tell how to use predicate builder and explaination.
I'm new to Borland C++ Builder and the application that I'm working on has to be launched from a ASP.net application on click of a button. That ASP.net application is able to launch other EXEs (made in C#) but when my application is launched it crashes immediately with a msg "an error has is encountered, tell microsoft about this problem" with button "Don't Send" "Send error report" and "debug". The ASP.net program is able to call "notepad.exe" which is probably not written on .net.
So, how do I call an application from ASP.net/c# which written in Borland C++ Builder and is launching successfully when I double click the application.
i just cant install VWD2008.But heres the thing, i have had it installed before along side VWD2010 about a 5 weeks ago.After download everything is ticked and says ok, after i exit, it cant be found, its really starting to drive me nuts and take my life over
SqlDataAdapter da = new SqlDataAdapter("select * from " + txtTableName.Text, DataStoreGeneral.GetConnectionString()); DataTable dt_app = new DataTable(); da.MissingSchemaAction = MissingSchemaAction.AddWithKey; da.FillSchema(dt_app, SchemaType.Source); da.Fill(dt_app); SqlCommandBuilder build = new SqlCommandBuilder(da); da.InsertCommand= build.GetUpdateCommand(); da.Update(ds.Tables.GetChanges(DataRowState.Added));
Problem: In my scenerio i had dataset with a table (in code->ds.Tables) in rowstate added. I wanted update on database with this table so i changed insert command of adapter to update command of command builder, but no update got performed. When debugged in sql profiler i found that update command generated by builder is checking all columns in where clause and with parameter value of data table instead of from database column value.
exec sp_executesql N'UPDATE [ShopResources] SET [GROUP_RESOURCE_ID] = @p1, [SEQ_NO] = @p2, [SUB_RESOURCE_ID] = @p3, [EFFICIENCY_FACTOR] = @p4, [RUN_COST_PER_HR] = @p5, [RUN_COST_PER_UNIT] = @p6, [BUR_PER_HR_SETUP] = @p7, [BUR_PER_HR_RUN] = @p8, [BUR_PERCENT_SETUP] = @p9, [BUR_PERCENT_RUN] = @p10, [BUR_PER_OPERATION] = @p11 WHERE (([GROUP_RESOURCE_ID] = @p12) AND ([SEQ_NO] = @p13) AND ([SUB_RESOURCE_ID] = @p14) AND ((@p15 = 1 AND [EFFICIENCY_FACTOR] IS NULL) OR ([EFFICIENCY_FACTOR] = @p16)) AND ([RUN_COST_PER_HR] = @p17)
AND ([RUN_COST_PER_UNIT] = @p18) AND ([BUR_PER_HR_SETUP] = @p19)
The problem I identified is parameter values inside where clause are from data table which is obvious that update condition will not be met. Is there some way to restrict where clause to primary key only in Command Builder?Or why is command builder taking where clause parameter values from datatable instead of command (query)?