User Profile

jaseem0712 · Dec 14 '14, 12:51 PM

in my page i have a code like this"

Code:

<td>
    <span>Sex:&nbsp;</span>
   </td>
    <td>
   <span id="Sex_PDLabel" runat="server"></span>
 
  </td>

while running the page i am getting some value here..i want to save that value in my sql server database..so i want to take that value in my code behind...

jaseem0712 · Feb 4 '14, 04:59 PM

I have a data grid view,,in third column of data grid view is combox box,,am filling thise

Code:

 Dim c As DataGridViewComboBoxColumn
            Dim cmd2 As New SqlCommand("select desigID,DName from Designation_tbl where deleted=0", con.connect)
            cmd2.CommandType = CommandType.Text
            Dim objdataadapter As New SqlDataAdapter(cmd2)
            Dim results As New DataSet

...

jaseem0712 · Jan 29 '14, 06:59 AM

I have a DataGridView, which has a image column:
Update Button_Click:

Code:

 Dim dtimage As Image
    {
        using (MemoryStream ms = new MemoryStream(rv.Row.Field<byte[]>("empimage"))) {
            dtimage = new Bitmap(ms);
        }
    }

Update query:

Code:

adapter.UpdateCommand == new SqlCommand("update DepartmentMaster_tbl set dtName = @dtName,dtPhone = @dtPhone,dtEmail

...

jaseem0712 · Jan 26 '14, 12:42 PM

I have a data grid view like this:

i am loading data grid view like this:

Code:

Dim cd As SqlCommandBuilder = New SqlCommandBuilder(adapter)
        adapter = New SqlDataAdapter("select c.cid,c.CompanyName,d.dtId,d.dtName as Department,d.dtPhone as Phone,d.dtEmail as Email,d.empimage from CompanyMaster_tbl c join  DepartmentMaster_tbl d on c.Cid=d.cId order by cid", con.connect)

...

jaseem0712 · Jan 22 '14, 08:18 AM

i have a data grid view like this:
in cell content click i wrote code like this:

Code:

If e.ColumnIndex = 4 Then
            Dim OFDLogo As New OpenFileDialog()
            OFDLogo.Filter = "JPEG(*.jpg)|*.jpg|BMP(*.bmp)|*.bmp"
            If OFDLogo.ShowDialog() = DialogResult.OK Then
                gv.Rows(e.RowIndex).Cells(4).Value = Image.FromFile(OFDLogo.FileName)
            End If

...

jaseem0712 · Jan 22 '14, 07:41 AM

I have a data grid view,in update button i wrote code like this:

Code:

    Dim cid As Integer
            Dim dtid As Integer
            Dim cmpname As String
            Dim dtname As String
            Dim dtPhone As String
            Dim dtEmail As String
            Dim dtimage As Image
    
    
            For i As Integer = 0 To gv.RowCount - 2

...

jaseem0712 · Jun 24 '13, 10:03 AM

I have Stored Procedure like this:

Code:

ALTER procedure [dbo].[carcallvalidation]
    @carid nvarchar(100)=null
    as 
    begin
    select t.TBarcode, t.Paid,t.Status,t.DelDate from Transaction_tbl t where TBarcode=@carid
    declare @transid integer=null
    select @transid= t1.transactID from Transaction_tbl t1 where TBarcode=@carid
    select count(k.transactid) transid from KHanger_tbl k where

...

User Profile

Profile Sidebar

how to get html genericconntrol value in code behind

system.form exeception data gridview combobox cell while inserting data to data grid

not properly updating image from DataGridView in winform application

after updating image from data grid view getting black color instead of images

saving images after editing,that time saving only last edited images in winform appli

after converting Bitmap back to MemoryStream not saving proper image

fetching second row out put of stored procedure