|
Why not post the question to the author? Use comments section at the bottom of the article...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
You are using a ASP.NET and ADO.NET to create an accounting application for your company.
You are writing code to run a set of stored procedures that perform posting operations in a
database at the end of each month. You use an OleDbConnection object to connect to the
database. You use an OleDbConnection object to connect to the database. You use an
OleDbCommand object to run the stored procedures. If an error occurs during execution of any
of the stored procedures, you want to roll back any data changes that were posted. You want the
changes to be committed only if all of the posting operations succeed. You write code to catch an
OleDbException object if an error occurs during the execution of a stored procedure. What else
should you do?
1. Call the Begin Trasaction method of the OleDbConnection object before running the stored
procedure. If an error occurs, use the OleDbConnection object to roll back the changes.
2. Call the BeginTransaction method of the OleDbConnection object before running the stored
procedures. If an error occurs, use the OleDbException object to roll back the changes.
3. Use the BeginTransaction method of the OleDbConnection object to create an
OleDbTransaction object. Assign the OleDbTransaction object to the Transaction property of
your OleDbCommand object. If an error occurs, use the OleDbTransaction object to roll back
the changes.
4. Use the BeginTransaction method of the OleDbConnection object to create an OleDbTransaction object. Pass a reference to the OleDbTransaction object to each stored procedure. Use error handling inside the stored procedures to roll back the changes
priya
|
|
|
|
|
Problems with homework? Let do yourself a favor - at least try to do it alone!!!
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
I m sorry.. But i couldn find out the correct answer......
|
|
|
|
|
And you will not. Except your teacher posted it somewhere on the web...
The only way is to get together all you learned and try to create a solution. If you have a solution that doesn't work correctly (some error) you always can come back here an ask about that specific error, however you will not get an out-of-box solution here specially for home-work assignments...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Thank You...
I'll try to get it done and find solution for this...
|
|
|
|
|
I want to know how to validate a textbox does not begin with the number 2
|
|
|
|
|
Use a RegularExpressionValidator[^]:
<asp:RegularExpressionValidator runat="server"
ControlToValidate="TheTextBox"
ValidationExpression="[^2].*"
ErrorMessage="The text must not start with '2'."
/>
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
thank you, It worked, please I'm looking for documentation on the regular Expression.
|
|
|
|
|
Regular expressions are a very complex topic, but there are lots of resources to help:
This specific expression - [^2].* - means:
- any character other than '2' (
[^2]), - followed by zero or more repetitions (
*) - of any character (
.) at all.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Use regex.
Please try doing the regex examples http://regexone.com/[^]
Please up vote if it helped you 
Thanks And Regards
Sibeesh
|
|
|
|
|
Hi,
I have Create Dynamic Controls on dropdown SelectedIndexChanged event
protected void ddlcount_SelectedIndexChanged(object sender, EventArgs e)
{
Table tbldynamic = new Table();
for (int i = 1; i <= count; i++)
{
tr = new TableRow();
tc1 = new TableCell();
tc2 = new TableCell();
tc3 = new TableCell();
tc4 = new TableCell();
TextBox _txtQty = new TextBox();
_txtQty.ID = "txtQtyRow" + i;
_txtQty.Width = 50;
TextBox _txtRate = new TextBox();
_txtRate.ID = "txtRateRow" + i;
_txtRate.Width = 50;
TextBox _txtAmount = new TextBox();
_txtAmount.ID = "txtAmountRow" + i;
_txtAmount.Width = 50;
CheckBox _chkRowNo = new CheckBox();
_chkRowNo.ID = "chkRowNo" + i;
_chkRowNo.Text = i.ToString();
tc1.Controls.Add(_txtQty);
tc2.Controls.Add(_txtRate);
tc3.Controls.Add(_txtAmount);
tc4.Controls.Add(_chkRowNo);
tr.Cells.Add(tc4);
tr.Cells.Add(tc1);
tr.Cells.Add(tc2);
tr.Cells.Add(tc3);
tbldynamic.Rows.Add(tr);
}
}
I need to get values from dynamically generated Textbox on Button Click Event.
I am trying below,
protected void btnSave_Click(object sender, EventArgs e)
{
CheckBox chk = (CheckBox)Page.FindControl("MainContent").FindControl("MultiviewId").FindControl("view1").FindControl("Panel1").FindControl("chkRowNo1");
}
Here
MainContent = ContentPlaceHolderID,
MultiViewId = MultiView,
ViewId = view1,
PanelId = Panel1,
chkRowNo1 = Dynamically generated checkbox
I have also tried
CheckBox chk = (CheckBox)Page.FindControl("chkRowNo1");
CheckBox chk = (CheckBox)Panel1.FindControl("chkRowNo1");
But no use. It shows an object reference error. While debugging it shows null.
Some one could you help me...
|
|
|
|
|
Hi
I want check box list combobox control in asp.net can any one help me?
Thanks
|
|
|
|
|
|
Thanks
|
|
|
|
|
Hello
I have three files in my simple 'Registration form' project - it inserts new user details into a MS Access database - comprising
an aspx, aspx.vb, and a Web.config file.
If I may post some of the code here, I was wondering if I can delete the following Sub Page_Load() from my aspx.vb file since I
can't see the purpose of it. In that aspx.vb file, I have:
Sub Page_Load()
Dim myMDBConnection As OleDbConnection = New OleDbConnection(ConfigurationManager.ConnectionStrings("Register").ToString().Trim())
myMDBConnection.Open()
'do stuff here
myMDBConnection.Close()
End Sub
Protected Sub CreateUser_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\myDatabase.mdb;")
Using conn
Dim Sql As String = "INSERT INTO userlist (username,password, strEmail) VALUES (@username,@password, @strEmail)"
Dim cmd As New OleDbCommand(Sql, conn)
conn.Open()
cmd.Parameters.AddWithValue("@username", username.Text)
cmd.Parameters.AddWithValue("@password", password.Text)
cmd.Parameters.AddWithValue("@strEmail", strEmail.Text)
cmd.ExecuteNonQuery()
conn.Close()
End Using
End Sub
End Class
And in my Web.config file I have:
<?xml version="1.0"?>
<configuration>
<connectionStrings>
<add name="Register" providerName="Microsoft.Jet.OLEDB.4.0;"
connectionString="C:\myDatabase.mdb;" />
</connectionStrings>
</configuration>
Would it be 'safe' to remove that Sub Page_Load()?
Thank you for any advice.
|
|
|
|
|
Look safe to me to delete, I don't see it really doing anything
|
|
|
|
|
Thanks jkirkerx 
Just removed it and all looks well!
Best regards
|
|
|
|
|
Right On!
You only needs page events if your going to use them.
Just as a rule, I use Page.Load to load data
and Page.Init to load controls or HTML in code behind.
|
|
|
|
|
So I could have used:
Protected Sub Page_Init(ByVal sender As Object, _
ByVal e As System.EventArgs)
username.Focus()
End Sub
|
|
|
|
|
No,
you create things that you want to persist during the page lifecycle.
So if you need a textbox, you make it in Page.Init, so when you post back to the server, the textbox and it's value will live through the postback.
If you make the textbox in page.load, it will show, but the textbox will die during postback, causing the value to die as well.
Make Sense?
You use Page.Load to load data the first time the form is shown, and to make adjustments to the form elements for first time viewing.
|
|
|
|
|
|
It's really important to learn the page lifecycle, before you get really fancy with your web apps. Otherwise you'll be posting many questions or headaches that don't make sense at that moment in time.
|
|
|
|
|
Yes, I can imagine it will avoid headaches in the future.
There seems to be an abundance of articles here:
http://www.codeproject.com/search.aspx?q=life+cycle&x=7&y=6&sbo=kw[^]
so I have made a note to try to come to terms with the basic concepts over the next few days.
I am grateful that you have stressed it's importance. I suppose it's like learning any human language: we put basic building blocks - grammar, vocabulary, etc - in place to construct the skeleton of the language and only afterwards do we add flesh to it.
Thanks again, jkirkerx
|
|
|
|
|
Hello:
i am using this kind of code for connection to the data base.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;
namespace Kiu_webS
{
public class Connections
{
SqlConnection _connection;
private string connStr = "";
public Connections()
{
connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
}
public Connections(string conStr)
{
this.connStr = conStr;
}
public string connectionString
{
get { return connStr; }
set { connStr = value; }
}
public SqlConnection GetDBConnection()
{
_connection = new SqlConnection(connStr);
return _connection;
}
public void connectDB()
{
try
{
_connection.Open();
}
catch
{
throw;
}
}
public void DisconnectDB()
{
try
{
_connection.Close();
}
catch
{
throw;
}
}
}
}
as i insert data from form to database i am getting this error. The coonection String property has not been initialized.
web.config file
<configuration>
<connectionStrings>
<add name="ConnStr" connectionString="Data Source = inayat; Initial Catalog = KIU; User ID=sa; Password=jan5562"/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0"/>
<authentication mode="Forms">
<forms name="KIUAuth" loginUrl="login.aspx" protection="All" path="KIUAuth/" timeout="30" slidingExpiration="true"/>
</authentication>
</system.web>
</configuration>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
