Get DS from BLL - ASP.NET Discussion Boards

Hi
I tried in both ways even making Hiddenbox to run at server.but i never understand the error which it is giving.

thnaks for reply..

Hi all,

I have a web page, where user can delete a record. I need to show a confirmation message and while googling i got the following code...

<asp:Button ID="Button1" runat="server" Text="Button" OnClientClick="return confirm('Are you sure you want to delete this record?');" OnClick="Button1_Click1" />

protected void Page_Load(object sender, EventArgs e)
{
Button1.Attributes.Add("onclick", "return confirm(\'Are you sure you want to delete this record?\');");
}

This works fine, but i don't know how to track the user response. When user hits No, i should be able track "false". Please tell me how to achive this..

Thanks in advance

Sebastian

Sebastian T Xavier wrote:
<asp:button id="Button1" runat="server" text="Button" <b="">OnClientClick="return confirm('Are you sure you want to delete this record?');" OnClick="Button1_Click1" />

protected void Page_Load(object sender, EventArgs e)
{
Button1.Attributes.Add("onclick", "return confirm(\'Are you sure you want to delete this record?\');");
}

The parts bolded above essentially do the same thing. I would suggest you stick with the OnClientClick one.

Basically by saying "return confirm('...')" in the clientside click event, if the user clicks "cancel" then the server postback will not occur. Therefore all you need to do is handle the server side click as the action to take when the user wishes to delete and you can rest assure that if they do click cancel than the server side handler will not be entered.

---

How to get answers to your questions[^]

Thank You

Sebastian

Please help me this is my error
Object reference not set to an instance of an object(pointing this statement) Obj.addNewProject(txtProjectName.Text, txtProjectAbb.Text, txtClientSite.Text, cmbProjectManager.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, ListBoxProjectMember.SelectedItem.Text, txtProDuration.Text, txtCompletionDate.Text, txtProjectDuration.Text, txtProDescription.Text)
*************
This is my Code for Button Save
************
Protected Sub ButtonSave1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonSave1.Click
Dim Obj As Businesslayer.TimeSheet = New Businesslayer.TimeSheet
Obj.addNewProject(txtProjectName.Text, txtProjectAbb.Text, txtClientSite.Text, cmbProjectManager.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, ListBoxProjectMember.SelectedItem.Text, txtProDuration.Text, txtCompletionDate.Text, txtProjectDuration.Text, txtProDescription.Text)
End Sub
**********
This is a class were I declared my variables
**********
Public Sub addNewProject(ByVal Project_Name As String, ByVal Project_Abb As String, ByVal Client_Name As String, ByVal Project_Manager As String, ByVal Project_Member As String, ByVal Project_Members As String, ByVal Est_Completion_Date As Date, ByVal Est_Project_Duration As Date, ByVal Project_Duration As Integer, ByVal Project_Description As String)
Dim Sql As String
Dim obj As Datalayer.Database = New Datalayer.Database
Sql = "insert into ProjectAdministration (Project_Name,Project_Abbreviation,Client_Name,Project_Manager,Project_Member,Project_Members,Est_Completion_Date,Est_Project_Duration,Project_Description,Confirm_Password,Project_Duration)" & _
" Values('" & Project_Name & "','" & Project_Abb & "','" & Client_Name & "','" & Project_Manager & "','" & Project_Member & "','" & Project_Members & "','" & Est_Completion_Date & "','" & Est_Project_Duration & "', '" & Project_Duration & "','" & Project_Description & "')"
obj.Execute(Sql)
End Sub
**********
I really don't understand this error.Can you please help me with it,What might be the problem?

Thanking you in Advance

oga m

It is hard to say what the problem is, but I would suggest that you put a break point in the code. Then check the objects to figure out which object is still set to Nothing. Once you figure out which object is set to Nothing then you might have a better idea of what is going on. If for some reason the code is getting executed in the load event the text boxes would not exist yet. Anyway, just a thought, hope it helps.

Ben

Oga M wrote:
Object reference not set to an instance of an object(pointing this statement) Obj.addNewProject(txtProjectName.Text, txtProjectAbb.Text, txtClientSite.Text, cmbProjectManager.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, ListBoxProjectMember.SelectedItem.Text, txtProDuration.Text, txtCompletionDate.Text, txtProjectDuration.Text, txtProDescription.Text)

Usually this error will come when you are trying to use an object that is not been initialized yet. Make sure all objects are initialized before you use them.

printf("Navaneeth!!")

www.w3hearts.com

My codes is shown below. Hopefully it should create a dataset. But how do I create a dataset in code using these values. Something like

<br />
Dim NewDataSet AS Dataset MadData.Cusomer_Lookup(Parameters here)

?

Public Class MadData<br />
    'get application settings<br />
<br />
<br />
<br />
<br />
    Public connectionString As String = ConfigurationManager.ConnectionStrings("MADConnectionString").ConnectionString<br />
<br />
    Public Function Customer_Lookup(ByVal CustomerType As Integer, ByVal CustomerForename As String, ByVal CustomerSurname As String, ByVal LimitedTradingName As String, ByVal NonTradingName As String, ByVal AddressMobile As String, ByVal Records As Integer, ByVal Query As String) As DataSet<br />
<br />
        'get the entity name to use for the DataSet table<br />
        Dim dbConnection As New SqlConnection(connectionString)<br />
        Dim dbDataSet As New DataSet<br />
<br />
        Try<br />
            'Create Command object for sp<br />
            Dim dbCommand As SqlCommand = New SqlCommand("Customer_Lookup", dbConnection)<br />
            dbCommand.CommandType = CommandType.StoredProcedure<br />
<br />
            'input parameter variables - CustomerType<br />
            Dim dbParameter As SqlParameter = dbCommand.Parameters.Add("@CustomerType", SqlDbType.Int)<br />
            dbParameter.Direction = ParameterDirection.Input<br />
            dbParameter.Value = CustomerType<br />
<br />
            'input parameter variables - CustomerForename<br />
            Dim dbParameter1 As SqlParameter = dbCommand.Parameters.Add("@CustomerForename", SqlDbType.VarChar)<br />
            dbParameter1.Direction = ParameterDirection.Input<br />
            dbParameter1.Value = CustomerForename<br />
<br />
            'input parameter variables - CustomerSurname<br />
            Dim dbParameter2 As SqlParameter = dbCommand.Parameters.Add("@CustomerSurname", SqlDbType.VarChar)<br />
            dbParameter2.Direction = ParameterDirection.Input<br />
            dbParameter2.Value = CustomerSurname<br />
<br />
            'input parameter variables - LimitedTradingName<br />
            Dim dbParameter3 As SqlParameter = dbCommand.Parameters.Add("@LimitedTradingName", SqlDbType.VarChar)<br />
            dbParameter3.Direction = ParameterDirection.Input<br />
            dbParameter3.Value = LimitedTradingName<br />
<br />
            'input parameter variables - NonTradingName<br />
            Dim dbParameter4 As SqlParameter = dbCommand.Parameters.Add("@NonTradingName", SqlDbType.VarChar)<br />
            dbParameter4.Direction = ParameterDirection.Input<br />
            dbParameter4.Value = NonTradingName<br />
<br />
            'input parameter variables - AddressMobile<br />
            Dim dbParameter5 As SqlParameter = dbCommand.Parameters.Add("@AddressMobile", SqlDbType.VarChar)<br />
            dbParameter5.Direction = ParameterDirection.Input<br />
            dbParameter5.Value = AddressMobile<br />
<br />
            'input parameter variables - Records<br />
            Dim dbParameter6 As SqlParameter = dbCommand.Parameters.Add("@Records", SqlDbType.Int)<br />
            dbParameter6.Direction = ParameterDirection.Input<br />
            dbParameter6.Value = Records<br />
<br />
            'input parameter variables - Query<br />
            Dim dbParameter7 As SqlParameter = dbCommand.Parameters.Add("@Query", SqlDbType.VarChar)<br />
            dbParameter7.Direction = ParameterDirection.Input<br />
            dbParameter7.Value = Query & "%"<br />
<br />
            'open the Connection; run the sp; transform to a DataSet<br />
            Dim dbDataAdapter As SqlDataAdapter = New SqlDataAdapter(dbCommand)<br />
            dbDataAdapter.Fill(dbDataSet)<br />
<br />
        Catch ex As System.Exception<br />
<br />
            Throw ex<br />
<br />
<br />
        Finally<br />
            'tidy up<br />
            dbConnection.Close()<br />
            dbConnection.Dispose()<br />
<br />
        End Try<br />
<br />
        Return dbDataSet<br />
<br />
    End Function<br />
<br />
End Class

You're missing an equals sign, but yes.

Hi everybody.

I'm migrating an aplication fromj2ee to .net (basically, framework 1.1 and vb.net as a language), and one of the main aspects to cover is a dockable and auto hide panel that the j2ee aplication has.

My problem is i do not find clear information on how it's can be implemented.

The dockable panel actually works on the j2ee app, and it works the following way:

The web site in jsp is coded using frames. The left frame contains a navigation menu using a treeview-like control (that i coded and it works now). Then, the frame has a tiny button on top, and if you click on it the frame works like an auto hide dockable panel, like the tools panels from visual studio.

That is. If someone point me on the right direction i will be very happy. Seriously Smile | :)

pd: sorry for my english, in my country we speak spanish Big Grin | :-D

"I hated myself... no, I hated my place in the world" - From Jerry Maguire

http://www.brothercake.com/site/resources/scripts/dbx/[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

hi vasudevan and thanx for your reply.

It's not what i've been searching for, but surely it puts me on he right direction. Anyway, i'm not an Ajax programer and examples like you gave me helps a lot to learn. And nice scripts too must say.

cheers!

"I hated myself... no, I hated my place in the world" - From Jerry Maguire

how many columns datagrid hav ??

The screen real estate, good user experience of the application and Memory alone would dictate this limit right?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Hi,
I'm wondering how to do this, I'm working on the on a datagrid and I'm using windows authentication. I managed to get username on to a login form, but I want it to be stored into the database.The code of web config looks like:
authentication mode="Windows"
identity impersonate="true"
And the Login page looks like on(Page_load):
Response.Write(Page.User.Identity.Name);
Thanks.

What exactly is ur problem??
If u want to get the windows login name then use:
HttpContext.Current.User.Identity.Name
or else tell us what is the exact problem.

All the Best...

Thanks,
I want is when any one uses the website the Windows Login name should appear in a particular datagrid column automatically.
Thanks.

Your problem is solved or not????

Not yet solved. When I try using: HttpContext.Current.User.Identity.Name; I get error: Only assignment, call, increment, decrement, and new object expressions can be used as a statement.
Thanks

varshavmane,
I think this will help anderstand my problem is there a way The windows login can be saved automatically into database whenever a user uses the website? since I'm working with datagrid.
Thanks

Hi

I am using the asp:hyperlinkField in asp.net For this I am writing the following code in .aspx page

<asp:hyperlinkfield navigateurl="~/KB/KB_Detail.aspx?id=<%#DataBinder.Eval(Container.DataItem, "PK_KnowledgeBaseID") %>" datatextfield="s_Title" headertext="Title">

But it is not working properly.Please tell me the problem

Regards

Karan

When you post code in a forum you need to check the box below that says Ignore HTML tags in this message (good for code snippets)
Otherwise the code gets removed and we won't see it.

Thanks,
Ben

How do you access a template field in the gridview and assign it to the string, especially in the rowcommand function

nzibi

wrote:

TemplateField contains ItemTemplate, which has id. You can find that control in code behind using FindControl method.

Here[^] is some code snippets for same.

Knock out 't' from can't,
You can if you think you can
Cool | :cool:

Please help me.I have declared my variables
***************************
Public Sub addTimesheet(ByVal IdNumber As String, ByVal ProjectName As String, ByVal ProjectMember As String, ByVal ClientSite As String, ByVal ProjectManager As String, ByVal Occupation As String, ByVal WeekNumber As Integer, ByVal Day As String, ByVal Hour As Integer, ByVal Description As String)
Dim Sql As String
Dim obj As Datalayer.Database = New Datalayer.Database
Sql = "insert into TimeSheet (Id_Number,Project_Member,Project_Name,Project_Manager,Hour,Day,Description,Client_Site,Occupation,Week_Number)" & _
" Values('" & IdNumber & "','" & ProjectName & "','" & ProjectMember & "','" & ClientSite & "','" & ProjectManager & "','" & Occupation & "', '" & WeekNumber & "','" & Day & "','" & Hour & "','" & Description & "')"
obj.Execute(Sql)
'addTimesheet = obj.GetDataset(Sql)
'obj.Close()
'Exit Sub
*******************************
Gives me this error
Conversion failed when converting the varchar value 'Select Project Manager' to data type int.(Pointing this query statement) lngRecords = cmdQuery.ExecuteNonQuery()
End Sub

******************
In my AddEntryButton

Dim Obj As Businesslayer.TimeSheet = New Businesslayer.TimeSheet

Obj.addTimesheet(txtIDNo.Text, cmbProjectName.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, cmbClientSite.SelectedItem.Text, cmbProjectManager.SelectedItem.Text, cmbOccupation.SelectedItem.Text, txtWeekNo.Text, cmbDays.SelectedItem.Text, txtHours.Text, txtDescription.Text)
*******************
What might be the Problem(explain it to me please)

oga m