Comments by Mayur Gujrathiii

Mayur Gujrathiii 31-May-11 6:35am View

your R&D over?

Mayur Gujrathiii 26-May-11 5:59am View

no not like that i want to fire radiobutton checked change event asynchronously as we can do it with the use of update panel but i want to do same with the help of javascript (xmlhttprequest)
Hope you got it now

Mayur Gujrathiii 25-May-11 9:16am View

your back up created successfully

Mayur Gujrathiii 25-May-11 8:37am View

backup databse DatabaseName to disk='c:\temp\DatabaseName.bak'

Mayur Gujrathiii 13-May-11 2:02am View

i am not getting
i have done as follows on checked change event
and i have also calling one javascript on checked changed

<asp:TemplateField HeaderText="SELECT">
<itemtemplate>
<asp:CheckBox ID="check" runat="server" OnCheckedChanged="check_CheckedChanged" ToolTip ="javascript:ViewSIGN();" AutoPostBack="true" Visible="true">

Protected Sub check_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs)

myds = DirectCast(ViewState("dsdata"), DataSet)

Dim chkbox As CheckBox = CType(sender, CheckBox)
Dim Grow As GridViewRow = CType(chkbox.NamingContainer, GridViewRow)

btnauthorise.Enabled = True
btnreject.Enabled = True

If (chkbox.Checked = True) Then

btnauthorise.Enabled = True
btnreject.Enabled = True
strCureentRowIndex = Grow.RowIndex
hdrowno.Value = strCureentRowIndex
reqslipno = myds.Tables(0).Rows(strCureentRowIndex)(1).ToString()
Boid = myds.Tables(0).Rows(strCureentRowIndex)(3).ToString()
imag.Visible = True
Image2.Visible = True
imag.ImageUrl = myds.Tables(0).Rows(strCureentRowIndex).Item("imagepath")
Image2.ImageUrl = hdimage2.Value
End If

End Sub

and

Mayur Gujrathiii 11-May-11 3:59am View

i mean to say how can i get that cell value simply

Mayur Gujrathiii 9-May-11 4:03am View

on one button click i am filing gridview like this

cmd.Parameters.AddWithValue("@pa_id", 0)
cmd.Parameters.AddWithValue("@pa_boname", "")
cmd.Parameters.AddWithValue("@pa_sholder", "")
cmd.Parameters.AddWithValue("@pa_chk_yn", 1)
cmd.Parameters.AddWithValue("@pa_rmks", "")
cmd.Parameters.AddWithValue("@pa_imagepath", "")
cmd.Parameters.Add("@pa_error", SqlDbType.VarChar, 8000)
cmd.Parameters("@pa_error").DbType = DbType.AnsiString
cmd.Parameters("@pa_error").Direction = ParameterDirection.Output
da.Fill(ds, "pr_ins_upd_reqdtls")
'If (Not (ds Is Nothing)) Then
If ds.Tables(0).Rows.Count > 0 Then

GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()

rowcount = ds.Tables(0).Rows.Count
lblsubheader.Text = "Records Found, " & rowcount & " "
'Dim name As String = ds.Tables(0).Rows(0)(11).ToString()
'Response.Write(name)
'lblsubheader.Text = name
'hdimage.Value = ds.Tables(0).Rows(0).Item("imagepath")

'Image2.ImageUrl = path
imag.ImageUrl = ds.Tables(0).Rows(0).Item("imagepath")
'Image2.Src = path
Image2.ImageUrl = hdimage2.Value
'lblsubheader.Text = hdimage.Value
Else
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
lblsubheader.Text = "No Record Found"
Image2.Visible = False
imag.Visible = False
End If
End Sub

and another button click trying to take values like this
Dim id As String = GridView1.Rows(0).Cells(1).Text

Mayur Gujrathiii 9-May-11 4:01am View

it is vb.net

Mayur Gujrathiii 7-May-11 7:44am View

compile time error

Mayur Gujrathiii 7-May-11 7:41am View

yes it is windows application

Mayur Gujrathiii 7-May-11 7:18am View

Ankur i have already stated there first read and then comment any thing

Mayur Gujrathiii 7-May-11 7:06am View

it is giving error on Application.StartupPath word key word not found

Mayur Gujrathiii 5-May-11 4:46am View

it is giving error on value keyword and after removing it application runs but "System.Web.UI.WebControls.DataControlFieldCell" is getting in lblheader.Text

Mayur Gujrathiii 5-May-11 4:41am View

not working means values are not coming and i correct it to count-1. but still not solved

Mayur Gujrathiii 28-Apr-11 9:02am View

error:Cannot find table 0

Mayur Gujrathiii 28-Apr-11 8:51am View

My stored procedure

USE [DMAT_SVV]
GO
/****** Object: StoredProcedure [citrus_usr].[pr_ins_upd_reqdtls] Script Date: 04/28/2011 10:17:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--select top 1 * from slip_issue_mstr
/*
create table Dis_req_Dtls_mak
(id numeric identity(1,1)
,req_slip_no varchar(100)
,req_date datetime
,Boid varchar(16)
,Boname varchar(150)
,sholder varchar(150)
,tholder varchar(150)
,created_dt datetime
,created_by varchar(100)
,lst_upd_dt datetime
,lst_upd_by varchar(100)
,deleted_ind smallint)

create table Dis_req_Dtls
(id numeric identity(1,1)
,req_slip_no varchar(100)
,req_date datetime
,Boid varchar(16)
,Boname varchar(150)
,sholder varchar(150)
,tholder varchar(150)
,created_dt datetime
,created_by varchar(100)
,lst_upd_dt datetime
,lst_upd_by varchar(100)
,deleted_ind smallint)

*/
ALTER proc [citrus_usr].[pr_ins_upd_reqdtls](@pa_id numeric
, @pa_action varchar(50)
, @pa_req_slip_no varchar(100)
, @pa_req_date datetime
, @pa_boid varchar(16)
, @pa_boname varchar(150)
, @pa_sholder varchar(150)
, @pa_tholder varchar(150)
, @pa_login_name varchar(100)
, @pa_chk_yn smallint
, @pa_rmks varchar(200)
, @pa_error varchar(8000) output
)
as
begin

if @pa_chk_yn = 0
begin

if @pa_action ='INS'
begin

insert into Dis_req_Dtls
select @pa_req_slip_no
,@pa_req_date
, @pa_boid
, @pa_boname
, @pa_sholder
, @pa_tholder
, getdate()
, @pa_login_name
, getdate()
, @pa_login_name
,1
,NULL
,@pa_rmks

end
if @pa_action ='EDT'
begin

update Dis_req_Dtls
set req_slip_no=@pa_req_slip_no
,req_date=@pa_req_date
,Boid=@pa_boid
,Boname=@pa_boname
,sholder=@pa_sholder
,tholder = @pa_tholder
,remarks = @pa_rmks
,lst_upd_dt = getdate()
,lst_upd_by =@pa_login_name
where id = @pa_id
and deleted_ind = 1

end
if @pa_action ='DEL'
begin

update Dis_req_Dtls
set deleted_ind = 0
,lst_upd_dt = getdate()
,lst_upd_by =@pa_login_name
where id = @pa_id
and deleted_ind = 1

end
if @pa_action ='VALIDATESELECT'
begin
select SLIIM_DPAM_ACCT_NO
, dpam_sba_no , isnull(DPHD_SH_FNAME,'') + ' ' + isnull(DPHD_SH_MNAME,'') +' ' + isnull(DPHD_SH_LNAME,'') sh_holder
, isnull(DPHD_TH_FNAME,'') + ' ' + isnull(DPHD_TH_MNAME,'') +' ' + isnull(DPHD_TH_LNAME,'') th_holder
from slip_issue_mstr , dp_acct_mstr left outer join dp_holder_dtls on dphd_dpam_id = dpam_id
where SLIIM_SLIP_NO_TO = replace(@pa_req_slip_no ,SLIIM_SERIES_TYPE,'')
and sliim_deleted_ind =1
end
if @pa_action ='SEARCH'
begin

select * from Dis_req_Dtls
where req_slip_no = @pa_req_slip_no
and deleted_ind =1

end

end
else if @pa_chk_yn = 1
begin

if @pa_action ='INS'
begin
if not exists(select req_slip_no from Dis_req_Dtls where id = @pa_id)
insert into Dis_req_Dtls_mak
select @pa_req_slip_no
,@pa_req_date
, @pa_boid
, @pa_boname
, @pa_sholder
, @pa_tholder
, getdate()
, @pa_login_name
, getdate()
, @pa_login_name
,0
, @pa_rmks

end
if @pa_action ='EDT'
begin
if not exists(select req_slip_no from Dis_req_Dtls where id = @pa_id and deleted_ind = 1)
begin
update Dis_req_Dtls_mak
set req_slip_no=@pa_req_slip_no
,req_date=@pa_req_date
,Boid=@pa_boid
,Boname=@pa_boname
,sholder=@pa_sholder
,tholder = @pa_tholder
,remarks = @pa_rmks
,lst_upd_dt = getdate()
,lst_upd_by =@pa_login_name
where id = @pa_id
and deleted_ind = 0
END
ELSE
BEGIN
insert into Dis_req_Dtls_mak
select @pa_req_slip_no
,@pa_req_date

Mayur Gujrathiii 27-Apr-11 10:09am View

yes dear

Mayur Gujrathiii 27-Apr-11 10:04am View

Thanks , i will take care of such silly mistakes

Mayur Gujrathiii 27-Apr-11 9:54am View

posted my code

Mayur Gujrathiii 27-Apr-11 9:53am View

Dim Var_StrLoginame As String = Session("LoginName")
Dim cmd As SqlCommand = New SqlCommand
Dim constr As String = ConfigurationManager.AppSettings("PooledConnectionString")
Dim sqlcon As SqlConnection = New SqlConnection(constr)
Dim da As SqlDataAdapter = New SqlDataAdapter("select * from Dis_req_Dtls_MAK", sqlcon)
da.SelectCommand = cmd
cmd.Connection = sqlcon
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "pr_ins_upd_reqdtls"
cmd.Parameters.Clear()
cmd.Parameters.AddWithValue("@pa_action", "SEARCHCHK")
cmd.Parameters.AddWithValue("@pa_tholder", ddlselect.Value)
If (filter.Value = "I") Then
cmd.Parameters.AddWithValue("@pa_boid", hdfilter.Value)
cmd.Parameters.AddWithValue("@pa_req_slip_no", "")
cmd.Parameters.AddWithValue("@pa_req_date", "")
ElseIf (filter.Value = "S") Then
cmd.Parameters.AddWithValue("@pa_boid", "")
cmd.Parameters.AddWithValue("@pa_req_slip_no", hdfilter.Value)
cmd.Parameters.AddWithValue("@pa_req_date", "")
ElseIf (filter.Value = "D") Then
cmd.Parameters.AddWithValue("@pa_boid", "")
cmd.Parameters.AddWithValue("@pa_req_slip_no", "")
cmd.Parameters.AddWithValue("@pa_req_date", hdfilter.Value)
End If
cmd.Parameters.AddWithValue("@pa_login_name", Var_StrLoginame)

'parameters not in use
cmd.Parameters.AddWithValue("@pa_id", 0)
cmd.Parameters.AddWithValue("@pa_boname", "")
cmd.Parameters.AddWithValue("@pa_boname", "")
cmd.Parameters.AddWithValue("@pa_sholder", "")
cmd.Parameters.AddWithValue("@pa_chk_yn", 0)
cmd.Parameters.AddWithValue("@pa_rmks", "")

cmd.Parameters.Add("@pa_error", SqlDbType.VarChar, 8000)
cmd.Parameters("@pa_error").DbType = DbType.AnsiString
cmd.Parameters("@pa_error").Direction = ParameterDirection.Output

'cmd.Parameters.Add("@pa_error", SqlDbType.VarChar, 800, "@pa_error")

'cmd.Parameters("@pa_error").Direction = ParameterDirection.Output

da.Fill(ds, "pr_ins_upd_reqdtls")

If (Not (ds.Tables(0).Rows.Count > 0)) Then

'GridView1.Visible = False
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
lblsubheader.Text = "No Records Found"
ElseIf ds.Tables(0).Rows.Count > 0 Then
Dim rowcount As Integer
rowcount = ds.Tables(0).Rows.Count
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
' ViewState("dsdata") = ds
lblsubheader.Text = "Records Found, " & rowcount & " "
End If
'Else
'lblsubheader.Text = "Enter Proper Date"
'End If

Catch ex As Exception
Response.Write(ex.Message.ToString())
End Try

Mayur Gujrathiii 27-Apr-11 9:52am View

i am calling all but where i am getting error i put it here

Mayur Gujrathiii 7-Apr-11 6:09am View

I am doing like this
<form id="frmstatehlp" runat="server" target="stateclient">

<table align="left" class="clsborder" border="0" cellpadding="0" cellspacing="0" >
<tr class="grhd">
<th class="grhd" align="left" style="height: 17px; width:10%">STATE</th>
</tr>
<tr ondblclick="getvalues(this);" onmouseover="this.bgColor='#FFFFFF'" önmouseout="this.bgColor='gold';" >
<td class="clstd" style="height: 17px; width:10%">ANDHRA PRADESH</td>
</tr>
<tr ondblclick="getvalues(this);" onmouseout="this.bgColor='#FFFFFF'" önmouseover="this.bgColor='gold';" >
<td class="clstd" style="height: 17px; width:10%">ARUNACHAL PRADESH</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">ASSAM</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">BIHAR</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">CHATTISGARH</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">GOA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">GUJARAT</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">HARYANA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">HIMACHAL PRADESH</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">JAMMU AND KASHMIR</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">JHARKHAND</td>
</tr>
<tr öndblclick="getvalues(this);" >
<td class="clstd" style="height: 17px; width:10%">KARNATAKA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">KERALA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">MADHYA PRADESH</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">MAHARASHTRA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px;

Mayur Gujrathiii 29-Mar-11 5:04am View

same connection string i am using in my both applications and problem is that it is giving error on + +Application.StartupPath + keyword

Comments by Mayur Gujrathiii (Top 23 by date)