I would like to know how i can see my programmatically declared dataset to be visible in the wizard (wizard of windows report....)dim datasett as dataset
View 3 RepliesI have a DataSet that I have added to my project where I can Insert and Add records using the Add Query function in Visual Studio 2010, however I want to add transactions to this, I have found a few examples but cannot seem to find one that works with these.
I know I need to use the SQLClient.SQLTransaction Class somehow. I used the Add New Data Source Wizard and added the Tables/View/Functions I need, I just need an example using this process such as How to get the DataConnection my DataSet has used. Assuming all options have been set in the wizard and I am only using the pre-defined adapters and options asked for in this wizard, how to I add the Transaction logic to my Database.
For example I have a DataSet called ProductDataSet with the XSD created for this, I have then added my Stock table as a Datasource and Added an AddStock method with a wizard, this also if a new item calls an AddItem method, if either of these fails I want to rollback the AddItem and AddStock in this case.
How can I set the value of WizardStep.IndexOf() programatically? eg.
[Code]....
when i add a dataset & using wizard trying to set the database using sql authentication.i get error login failed for user sa but if i use windows authentication i get connected.i checked the sql server it has mixed authentication but still i am not able to create the xsd & suppose i copy the the dataset mad eon other system to this system i am bale to aceess the data in the application but not able to configure or preview data.how do i rectify .
View 1 RepliesI have 2 views in sql server and I create a dataset with those 2 views as datatables. Now I need to create a datatable and programmatically fill it with the other 2 datatables. Take the 2 datatable and create a third one in the dataset not create a third view in sql server.
View 2 RepliesI've developed an application using strong-typed dataset with .net framework 3.5.is there a way to change the source table for a tableadapter programmatically?
View 1 RepliesI am trying to use wizard in an update panel but the wizard is disappearing when I click for the next or prev step button. I only want to close wizard , when I click the finish button. How can I do this ?
View 1 RepliesI have a gridview that is bound to a SQL datasource and is filtered via FilterExpression,
the FilterExpressoin is using Contro Parameters in a for of textboxes.
I want a certain button to become visible (btnInsert.Visible=true) when the filterExpression returns no results.
what event should I use? what is the code for that?
I have five menu items that i have created as a user control and placed on the master page. Now i want one of the menu items to be visible only for particular user role and not visible for others. Here is what I did. Its not working though.
Dim DST As New DataSet
DST = dataObject.RunSPReturnDataSet("uspUserProfile '" & Session("UserID").ToString & "'", "mytbl")
'Dim US As New DataSet
[Code]....
[Code]....
[Code]....
[Code]....
I have a web page that I have a media control player on along with other controls in a table.It's a training video, so the controls are not visible.So the user can advance to the next web page,I thought I would have a button control inside an update panel with a time control so that the user had to watch the video and then the button control would appear after the video completed.I'm setting the button update panel to NOT visible and then turning it one when the time control elapses the same amount of time that the video runs.My problem is that when I set the visible property of the update panel to NOT visible it also makes the media player's panel NOT visible too.They are in two different panels.The medial player in a standard panel and the timer control connected witha separate panel that contains the button for the user to proceed. When I set the visible property to "true" the media player runs but the update panel with the button is visible also.
[Code]....
This is the code for the update panel and continue button that is in a separate table cell.I even split the table and so this is in a completely separate table but I still get the same behavior.
I am learning asp.net using Visual web developer 2008 express.
I have an image control with the html code below
<div class="Header">
<asp:Image ID="image1" runat="server"
ImageUrl="D:/Master/test.jpg" Width="500" Height="300"
AlternateText="UNRA Fort Portal Intranet"/>
</div>
In design view, the image shows but when i run the app, the image is not shown. Only the alternate text is displayed.
The css code code as below.
.Header
{
top:10px;
left:20px;
position:absolute;
width:800px;
background-image:URL(D:/Master/test.jpg);
background-repeat:repeat-x;
}
In my project I work with Entity Framework (LINQ to ENTITY). I only have ADO.NET Entity Data Model and a DAL (Data Access Layer). I also get the data due a WCFClientService. I have a gridview that needed to be exported in Excel.
FlexCel is a tool for generating Excel files based on a template. The only thing I see in demo's is that they work with DataSets.
Is there a way to convert the data in my gridview to a virtual DataSet?
I've written the following method to get the data:
[Code]....
there is a way to make a label visible for a seccond and then make it visible =false ; ?without javascript... just c# ,,,
View 4 RepliesI know the back button always presents a problem, but this one doesn't make any sense.
I have a simple details view and a button on a page. The button sends the user to the homepage. I am trying to prevent the user from being able to use the detailsview if they click Back in their browser.
This is the button click event
[code]....
When the button is clicked...oddly the user is sent to the homepage then when they click the browser back button they are sent to previous page with the detailsview still visiible.
I know I am missing something, can someone fill me in?
Why is the detailsview still visible?
Till now I used to design RDLC file before and assigned typed dataset table columns.Report processing mode is local. But now my stored procedure returns different columns based on condition i.e columns are not fixed every time. Now I need to add that columns to typed dataset and dataset is assigned to RDLC file. So dataset and RDLC files are create dynamically based on stored procedure result set columns.
View 1 RepliesWhat I am thinking is this? Is it possible for me to upload the data from an excel file to dataset of my application first, so that the user can view the data in a gridview to review it first, before the user strike the save button, to save it in the database. So, that in case there is a problem, the gridview will high light all the data with an error. So the user can easily pull out the excel and correct the data before saving it in the database.
View 4 RepliesToday I am facing the problem with Typed DataSet using DataSet.XSd file, And How to fetch, Delete and Update the Database through Dataset.xsd file.
View 9 Replieshow do i copy required row in dataset to a new dataset. i have bind a xml into a dataset and i need to display say row 3 to 5 only so i do a for loop but i have encounter problem when trying to copy the rows to a new dataset.
do i have to write the xml to datatable and bind it to dataset and from there copy over ?
I get this error when using the code:
[Code]....
What could be the reason for this, as in the offline develope environment I had no problems using this code. Or do I need to create a workaround?
I m new in asp.net c#.
How to declare a oledbconnection object in asp.net c#.
Means should it be declared as a static or public?
ex:- suppose the object is OleDbConnection con;
Whether it should be static OleDbConnection con;
Or public OleDbConnection con;
I get the above error while compiling and the name is in my .aspx file while i try to assign it in my .vb file like this
IN .aspx file:
<tr>
<td class="txtarialsml">SEC Fee</td>
<td> <asp:TextBox runat="server" ID="txtsec" Width="150px" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px" ReadOnly="true" CssClass="txtverdlink" Height="18px"></asp:TextBox></td>
</tr>
<tr>
<td class="txtarialsml">CSCS Fee</td>
<td> <asp:TextBox runat="server" ID="txtcscs" Width="150px" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px" ReadOnly="true" CssClass="txtverdlink" Height="18px"></asp:TextBox></td>
</tr>
<tr>
<td class="txtarialsml">NSE Fee</td>
<td> <asp:TextBox runat="server" ID="txtnse" Width="150px" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px" ReadOnly="true" CssClass="txtverdlink" Height="18px"></asp:TextBox></td>
</tr>
In .VB file
Protected Sub drpstock_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles drpstock.SelectedIndexChanged
Try
txtsec.Text = ""
txtnse.Text() = ""
txtcscs.Text() = ""
Catch ex As Exception
Session("errorcode") = "blabla"
Session("errordesc") = "This exception occurred while trying to fetch data."
Response.Redirect("../errorpage.aspx")
End Try
End Sub
Public Sub dg_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs)
Dim row As DataGridItem = e.Item
lblData.Text = "in subprocedure"
If row.ItemType = ListItemType.Item OrElse row.ItemType = ListItemType.AlternatingItem Then
Dim day As DateTime = Convert.ToDateTime(DirectCast(row.DataItem, DataRowView)("day").ToString())
Dim tempMonth As Integer = day.Month
Dim lblMonth As Label = DirectCast(row.Cells(0).FindControl("lblMonth"), Label)
If row.ItemIndex = 0 Then
UpdateLabel(lblMonth, day)
End If
If currMonth <> tempMonth Then
'add blank row
currMonth = tempMonth
j += 1
AddRow(row.ItemIndex + j)
UpdateLabel(lblMonth, day)
End If
End If
End Sub
I have this line of code on my aspx page that works fine.
[Code]....
i now want to put the same code in a user control, this is when i get the error.
how can i get 'ClientScript' work on usercontroll
I know I have to be missing something simple, but yes, it's stumped me. I've read a couple posts that are similar, but didn't correct my issue. This seems too easy, so here's my situation. I have a Login.aspx (using VB). Here's my (partial) code for this page:
[Code]....
Then in the Login.aspx.vb, I'm getting the error as stated in this posts subject line:
[Code]....
At a bit of a loss here. As the subject says, I have a repeater control that uses the variable xmlN which is declared in my Sub Page_Load. Posted code below.
[Code]....