|
You can't.
If the schema isn't known at design-time, the designer can't do anything with it. You're only going ot be able to do that at run-time.
The bigger question should be why that table has an unknown number of columns. Is this really necessary or can the data be represented differently to eliminate this condition.
Do these column have to appear in the report? Is there is a subset of columns that is known? Can these be broken out into a seperate table?
Tons of questions only you can answer...
|
|
|
|
|
Put all the columns in the report and control the visibility/width of the columns based on the users choice! It's still a really ugly requirement!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I'm using Stored Procedure,3 tier and VB.net.
Now, i click the gridview and then want to show the data in textboxes and pictureBox to update the informations.
The problem is that , how can i retrieve photo to picture box???
Here is my code
Private Sub gdCompany_CellClick(ByVal sender As System.Object, ByVal e As Telerik.WinControls.UI.GridViewCellEventArgs) Handles gdCompany.CellClick
btnSave.Text = "ျပင္ရန္"
txtCompanyName.Text = gdCompany.CurrentRow.Cells(1).Value.ToString()
txtDescription.Text = gdCompany.CurrentRow.Cells(2).Value.ToString()
txtPhoneNo.Text = gdCompany.CurrentRow.Cells(3).Value.ToString()
txtFaxNo.Text = gdCompany.CurrentRow.Cells(4).Value.ToString()
txtEmail.Text = gdCompany.CurrentRow.Cells(5).Value.ToString()
txtWebsite.Text = gdCompany.CurrentRow.Cells(6).Value.ToString()
ddlBankName.SelectedValue = Convert.ToInt32(gdCompany.CurrentRow.Cells(7).Value.ToString())
ddlBankBranch.SelectedValue = Convert.ToInt32(gdCompany.CurrentRow.Cells(8).Value.ToString())
txtBankAccountNo.Text = gdCompany.CurrentRow.Cells(9).Value.ToString()
txtAddress.Text = gdCompany.CurrentRow.Cells(10).Value.ToString()
txtCompanyName.Focus()
End Sub
|
|
|
|
|
I'd recommend creating a "new application" to try implement this technique; that way you won't be bothered with code that has little to do with this particular problem.
You already have the bytes; you can put those in a memorystream[^] and load your image from that stream[^].
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
hy
This function converts byte array to image:
Public Shared Function ByteArrayToImage(ByVal ByteArr() As Byte) As Object
Dim ImageStream As System.IO.MemoryStream
Try
If ByteArr.GetUpperBound(0) > 0 Then
ImageStream = New System.IO.MemoryStream(ByteArr)
Return Image.FromStream(ImageStream)
Else
Return Nothing
End If
Catch ex As Exception
Return Nothing
End Try
End Function
and this convert back:
Public Shared Function ImageToByteArray(ByVal NewImage As Image) As Object
Dim ImageStream As System.IO.MemoryStream
Dim ByteArr() As Byte
Try
ReDim ByteArr(0)
If NewImage IsNot Nothing Then
ImageStream = New System.IO.MemoryStream
NewImage.Save(ImageStream, Imaging.ImageFormat.Jpeg)
ReDim ByteArr(CInt(ImageStream.Length - 1))
ImageStream.Position = 0
ImageStream.Read(ByteArr, 0, CInt(ImageStream.Length))
End If
Return ByteArr
Catch ex As Exception
Return Nothing
End Try
End Function
+You need DBNull check when the column allow nulls.
|
|
|
|
|
'In DA_Company'
Function Company_Save(ByVal M_Model_DA As Model.M_Company) As String
Try
connection_enable()
cmd = New SqlCommand()
cmd.CommandText = "SP_HR_Company_Insert"
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@Company_Logo", SqlDbType.Image).Value = M_Model_DA.Company_Logo
err_message = cmd.ExecuteNonQuery()
Catch ex As Exception
err_message = ex.ToString()
End Try
Return err_message
End Function
'In BL_Company'
Function Company_Save(ByVal M_Company_BL As Model.M_Company) As String
Try
DA_Company = New DataAccess.DA_Company()
error_message = DA_Company.Company_Save(M_Company_BL)
Catch ex As Exception
error_message = ex.ToString()
End Try
Return error_message
End Function
'In M_Company'
Public Property Company_Logo() As Byte
Get
Return Me.CompanyLogo
End Get
Set(ByVal value As Byte)
Me.CompanyLogo = value
End Set
End Property
'In Frm_Company'
Private Sub Company_Save()
Try
BL_Company = New BusinessLogic.BL_Company()
M_Comapny = New Model.M_Company()
M_Comapny.Company_Logo = Convert.ToByte(browseCompanyLogo.Value)
error_message = BL_Company.Company_Save(M_Comapny)
If error_message > 0 Then
MessageBox.Show("Complete Save")
Company_GridView_FillData()
End If
Catch ex As Exception
MessageBox.Show(ex.Message.ToString())
End Try
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Company_Save()
End Sub
But It Shows Input Stream was not in a correct format . Why ? please !
|
|
|
|
|
heinhtataung wrote: Why ?
'cause an exception occured. Can you point out the line *where* it occurs?
I'd guess it happens on this line;
M_Comapny.Company_Logo = Convert.ToByte(browseCompanyLogo.Value)
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Hi I've recently started programming and for a project i need to learn how to create my own AI program and i need to understand how it is done I need to know everything from opening VB i can do basic thing in VB but i have no idea were to even start with this can someone help please from the very start or at least help a little Thankyou anyone who helps
|
|
|
|
|
I would start at MSDN Development for beginners[^]
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
ill try this thankyou
|
|
|
|
|
Casey Edison wrote: how to create my own AI program Even the Japanese struggled with that.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
I don't want to make a very complex one just one that can make replys and activate event from speech, not to complex ofcourse i know there is AI programs you can download like this like helpful AL like that basically.
|
|
|
|
|
OK, so what exactly are you asking for here?
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
I want to be able to make a basic program that i can run. I want it to be able to use speech recognition but i dont mind using text, with some sort of speech from the AI. like siri basically.....
i understand this might sound like facepalm. I know Siri was created by proffesionals over years under the CALO project. I obviously dont want it as complex as Siri.
i uderstand for actually siri the framework is python and java i dont mind changeing programming languages aslong as i can create this myself, the language doesnt matter.
|
|
|
|
|
All these things are possible, but it would be quite a challenge for someone who is still learning programming. The first thing you need to do is study your language of choice and get comfortable with building simple programs.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
i can do basic things i understand variables can make a simple replica of notepad, and number calculator but a basic one and just basic programs really im also tryna learn how to make a media player at the moment, but its just getting off the ground with this is hard.
|
|
|
|
|
Casey Edison wrote: just getting off the ground with this is hard. No one said it would be easy; programming requires considerable thought and effort. Don't assume that you can turn out a complex application after just a few days. The only way to produce great, or even good, work is practice, practice, practice.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
i know this but nothing wrong with asking for help then i can practice
|
|
|
|
|
Casey Edison wrote: nothing wrong with asking for help Help with what? All we know is that you want to write some sort of AI program in Visual Basic. Unless you explain exactly what you are having difficulty with we cannot suggest much more than: "try some Google searches for AI".
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
i can do basic things i understand variables can make a simple replica of notepad, and number calculator but a basic one and just basic programs really im also tryna learn how to make a media player at the moment, but its just getting off the ground with this is hard. Do you know were i could ind out how an AI works how the code links etc.
|
|
|
|
|
Casey Edison wrote: i can do basic things i understand variables can make a simple replica of notepad, and number calculator but a basic one and just basic programs really im also tryna learn how to make a media player at the moment, but its just getting off the ground with this is hard. Do you know were i could ind out how an AI works how the code links etc.
An AI is a few levels complexer than a notepad. Google for "Eliza", there must be some chatbot-code around that you could build on.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Hi, anyone can give me idea on how to do this? I'm used to gridview for updating multiple data to sql table. But how can i insert to sql table a list of data from a table/form? Its a situation where a lecturer wants to register a list of student for a subject.
|
|
|
|
|
One way would be to issue INSERT commands, using Sql. Another way would be using the TableAdapters. Both approaches are described here[^].
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
sorry.. still cant understand how it works.
i have a html table where there are 3 columns studentID,studentName, courseName. There ada 10 rows of textbox for each column. Can u explain how can i use the one that u gave me? I'm not using gridview because my data doesn't exist in the sql table yet. Hope my explanation is clear because my english is not that good.. TQ for the reply... been waiting every minutes for reply
|
|
|
|
|
zaimah wrote: sorry.. still cant understand how it works.
i have a html table where there are 3 columns studentID,studentName, courseName. There ada 10 rows of textbox for each column. Can u explain how can i use the one that u gave me?
That explanation would not fit in a single post.
zaimah wrote: I'm not using gridview because my data doesn't exist in the sql table yet.
You'd need to CREATE TABLE before the INSERT . Both are done using Sql, a separate language with it's own syntax. The other method that's being described in the documentation, is the TableAdapter-approach, where the framework generates these commands on your behalf.
zaimah wrote: been waiting every minutes for reply
As opposed to waiting, find yourself a tutorial, an article, anything that gets you moving in the right direction. It might take a few days before you get a satisfactory answer.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|